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

No comments: