You can also use tr for this. For example to convert CHAR(13) to CHAR(10):
tr '\r' '\n' < source.csv > destination.csv ----- Original Message ---- From: "[email protected]" <[email protected]> To: U2 Users List <[email protected]> Sent: Tue, April 13, 2010 8:36:44 AM Subject: Re: [U2] import data to excel sheet... Don't know if this helps, but UNIX generally provides a pair of utilities called dos2unix and unix2dos that handle the conversion. They can be used in scripts, etc. >>This is a function of the operating system. On Unix systems only a linefeed >>character is added to the end of a line whereas on Windows both carriage >>return and linefeed characters are added to the end of a line. If you open a >>file created on a Unix system with the notepad app it will have one line >>with strange characters in it. A quick fix, if you open the same file with >>word pad it will be converted and you can save it. If you created a file on >>a Unix system for use on a Windows system you have to add a carriage return >>character to the end of the line. >>Jerry Banker Charles Shaffer Senior Analyst NTN-Bower Corporation _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
