MS Excel and line terminators

Hi,

I've opened a text (tsv) file in excel, then saved it, and now my line terminators are screwed (they normally were 0x0A, but now they became 0x0a 0x0d). I can no longer work with this file in console

Is there any way to say MS Excel to preserve 0x0a when saving text files, which is default osx line terminator?

Are you sure you don't mean 0x0D0A? Excel, being a Microsoft program, will naturally export to MS DOS/Windows line endings (CR+LF, or 0x0D0A)

I very much doubt there's any way to convince Excel to change its behavior, but it should be a simple matter to strip out the line endings using the sed command, or your favorite editor.

technologist said:

Are you sure you don't mean 0x0D0A? Excel, being a Microsoft program, will naturally export to MS DOS/Windows line endings (CR+LF, or 0x0D0A)

I very much doubt there's any way to convince Excel to change its behavior, but it should be a simple matter to strip out the line endings using the sed command, or your favorite editor.

Click to expand...

Thanks, technologist, you must be right on 0x0D0A. But the order doesn't really matter in this case, but rather the presence of '0D', which screws things up.

I wonder what kind of 'bad ***' one needs to be, to output text files in *UNIX* version of the software with hard coded *Windows* line terminators???

Oh, well Regarding using `sed`, yes, this is possible of course, but too much trouble.. I'd better use OpenOffice for this particular task, which manages it beautifully.

vanyatka said:

Regarding using `sed`, yes, this is possible of course, but too much trouble.. I'd better use OpenOffice for this particular task, which manages it beautifully.

Click to expand...

Can't argue with that.