Tag: CSV

How to Fix ^M Characters in Vim

I opened a CSV file in Microsoft Excel. I approved compatibility with macros on a Mac. Then, I opened the same CSV file with vim.

The entire CSV file was reduced to a single line whenever I opened the file with vim.

Something like this:

Number of Sloths,Type^M15,black^M10,brown^M5,blue
m-character-data
Example of the ^M character on every line in vim.

If we try to substitute all the ^M characters, those characters aren’t found!

vim slothparadise.csv

The characters are actually a little different. We use vim‘s substitution for \r.

:%s/\r/\r/g

All the ^M characters should be exchanged to be proper new lines.