Sometimes when I saved a sheet from Excel on a Windows or Mac OSX computer as a tab-delimited file for further data processing, I frequently encountered the annoying ‘^M’ issues. To save my own time and to help the others who have the same issues, here are the solutions:
Open the file you want to convert with
vim, then replace the ‘^M’ characters to
\r like this:
CTRL-V+CTRL-M really means hold your Control-V and Control-M keys, which will be finally shown as ‘^M’ in place.
Alternatively, you can also simply use the