I have code that successfully reads a CSV file using FasterCSV and puts
the data into a simple, 2x2 array.
Some of the cells I read in and print out to a file contain some kind of
a control character that I don’t know how to strip out and substitute
with formal line feeds or carriage returns.
Data in original spreadsheet cell that gets read in as CSV reads:
- String A
- String B
Data, after reading CSV file and printing out cell to a file reads:
- String A^M^MString B
My problem is that I need to get the latter output to look like the
Does anyone know a quick and simple way to parse the string for the
control character “^M^M” and replace it with a formal line feed or
Thanks for your help,