Shell Programming and Scripting

Hi All,
We are getting an external file in abc.csv format. When opened in excel spread sheet, it is opening alright. But when opened in notepad, I see the contents in a single line.
Ftp'd the file in binary mode to AIX UNIX host. When opened, I see Control M (^M) characters in place of New Line characters.

I did the following:
$ wc -l abc.txt
0 abc.txt
$ sed 's/^M//g' abc.txt > xyz.txt
$ sed 's/^M$//' abc.txt > xyz.txt

I'm unable to replace the ^M character with new line. Can you kindly help me with the solution?

Thanks in advance.

Code:

dos2unix abc.txt abc.txt

will remove control ^M characters

Makarand, we don't have this utility. Any other way to replace he ^M characters in shell script?

if you have "Editplus" then save as the file and try choose file format as "Unix"
if you have "or "Notepad++" then save as the file as "unix script file"
OR
open the file in wordpad and instead of FTP it ; try to copy the file contents and then vi filename & paste in Unix

Sorry Makarand but I need to do this as part of the shell script.

I also tried the below.

sed 's/'"$(printf '\015')"'//g' abc.txt > xyz.txt

It removed the ^M character but it is not replaced with newline character.

Please note that the original file is showing all data in single line with new line being displayed as ^M. When I do "wc -l abc.txt", it displays 0 rows indicating it is not recognising any new line characters.

My goal is to introduce these newline characters so that I can process the data row by row

Thanks!!

What is the output of this command:

Code:

file abc.txt

abc.txt: ascii text