Shell Programming and Scripting

A search in this forum can help you.

Trying to remove '^M' characters from a file.

In addition to the other advice that you received, you should also search for "perl one liners remove control M". There seems to be no end to the number of things that can get done with perl one liners.

I'm assuming that abc.csv was created from excel on a mac in which case this should work:

Code:

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

Try looking for the dos2unix command in /usr/bin/dos2unix.
It's possible that you don't have /usr/bin in your path.

You can also try echo $PATH

Thanks to all that tried to help me.

I didn't find /usr/bin/dos2unix on our UNIX host.

xbin - the cmd didn't work.

I tried the below cmd...seems working..

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

Note that after first "\" (back slash), I pressed return key (Enter key) that took me to the next line with ">" symbol. This seems to have replaced ^M character with newline. I'll confirm/reply after my testing.

According to forum rules, you should search the forum for asking questions. Obviously, this question has been asked and answered a number of times, including:

Which one is faster to remove control m characters?

Yes it worked!

In the shell script, when I pressed Enter key, it didn't display ">" symbol but started the next characters from new line....

$cat Test.ksh
#!/bin/ksh

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

---------- Post updated at 02:40 PM ---------- Previous update was at 02:38 PM ----------

Neo - I did searched the forum before posting my query. Pls see what commands I tried in the initial post under this thread. I got those leads from searching the form itself.

I posted my query only when the answers on the other questions didn't help me.

Hope you understand.

Thanks!

---------- Post updated at 02:45 PM ---------- Previous update was at 02:40 PM ----------

How can I mark this thread as solved?