Friday, June 19, 2009
Mac Office Excel - all text exports appear as one line
If you use Mac Office to convert a spread-sheet to text, you will see one long line with any Unix utility. The reason is that Office inserts the windows carriage return (^M) with no line feed.
To fix this, bring up the text file inside vi editor type:
this will appear on the editor like
as ^V is really an escape for control characters
Post a Comment
Post Comments (Atom)