Replace ^M character of Windows with newline on linux/Mac

Sometime exported data from excel may contains ‘^M’ issues, so that cannot process data further without removing the annoying ‘^M’. Approach to replace ‘^M’ characters with newline in *inux.

Open the file via vim, then replace the ‘^M’ characters which generate by ctl-v+ctl-m with \r like this:

:%s/ctl-v+ctl-m/\r/g
:wq