Saturday 17 March 2012

Using Excel for Bioinformatics Data: Five Issues, Five Solutions



Using Excel for Bioinformatics Data: Five Issues, Five Solutions
http://info.5amsolutions.com/bid/120220/Using-Excel-for-Bioinformatics-Data-Five-Issues-Five-Solutions

Nice tips !
I had been wondering about the Issue: Mistaken SYLK Files for the longest time! Forgot how I solved it eventually. MacOS excel also appears to have different default behavior. In windows I used to be able to open .csv files and there will be a dialog box asking me what are the field separators in the file (:,;,|,tab,space)

Now my just run everything thru sed to change it to commas so that it works.

 Sed 's/tab/,/g' file > file.csv
 Open file.csv

No comments:

Post a Comment

Datanami, Woe be me