I opened a CSV file in Microsoft Excel. I approved compatibility with macros on a Mac. Then, I opened the same CSV file with
The entire CSV file was reduced to a single line whenever I opened the file with
Something like this:
Number of Sloths,Type^M15,black^M10,brown^M5,blue
If we try to substitute all the
^M characters, those characters aren’t found!
The characters are actually a little different. We use
vim‘s substitution for
^M characters should be exchanged to be proper new lines.