How to replace end of line characters
Posted on 2004-09-22
I learned it but I can't remember it!
When I bring over datafiles from my Windows XP box to upload into the Oracle DB I save the Excel file as a .csv file. I then FTP it to the UNIX box.
When I open it up in VI on the UNIX box (HPUX 10.2) I have ^M as the end of line character for each line.
How do I do a replace with nothing on the ^M using Replace, SED or whatever??. Should I be changing a setting somewhere in my FTP so that I don't get the odd character??
Thanks, Jerry (just learning)