When you save .xls file to .csv in Mac,
If you see a bunch of ^M's in the file,
you have Mac line breaks.
To convert it to Unix readable format.
$tr '^M' '\n' < src.csv >dist.csv
Reference:
http://obswww.unige.ch/~segransa/HELP/replace.html
No comments:
Post a Comment