remove ^M characters from file using sed

Question

I have this line inside a file:

ULNET-PA,client_sgcib,broker_keplersecurities ,KEPLER 

I try to get rid of that ^M (carriage return) character so I used:

sed 's/^M//g' 

However this does remove everything after ^M:

[root@localhost tmp]# vi test ULNET-PA,client_sgcib,broker_keplersecurities^M,KEPLER  [root@localhost tmp]# sed 's/^M//g' test ULNET-PA,client_sgcib,broker_keplersecurities 

What I want to obtain is:

[root@localhost tmp]# vi test ULNET-PA,client_sgcib,broker_keplersecurities,KEPLER 

Answer 1

Use tr:

tr -d '^M' < inputfile 

(Note that the ^M character can be input using Ctrl+VCtrl+M)

---

EDIT: As suggested by Glenn Jackman, if you're using bash, you could also say:

tr -d $'\r' < inputfile 

Answer 2

still the same line:

sed -i 's/^M//g' file 

when you type the command, for ^M you type Ctrl+VCtrl+M

actually if you have already opened the file in vim, you can just in vim do:

:%s/^M//g 

same, ^M you type Ctrl-V Ctrl-M