Monday 8 September 2014

Convert Mac Format File to Unix Format File

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