UNIX style return characters.

[Richard]

I'd like to save a worksheet as tab-delimited text with UNIX style
return characters (i.e. \n) instead of Mac style (i.e. \r). Is there
any way to do this in Mac Office 2004?

Also I see options to save as both Text(Windows) and Text(MS-DOS). What
is the difference?

 

[JE McGimpsey]

I'd like to save a worksheet as tab-delimited text with UNIX style
return characters (i.e. \n) instead of Mac style (i.e. \r). Is there
any way to do this in Mac Office 2004?

Also I see options to save as both Text(Windows) and Text(MS-DOS). What
is the difference?

Text(Windows) and Text(MS-DOS) use the double End-of-line (EOL)
characters Carriage Return/Line Feed (CRLF).

Macs use just CR as EOL, while Unix uses just LF.

AFAIK, there's no way to natively save with just the LF EOL character
from XL. You could certainly use a macro, but it's probably just as easy
to use something like this in the Terminal.app:

tr '\r' '\n' < macformat.txt > unixformat.txt