I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them with quotes, but Excel doesn't seem to recognize the CR character and puts a little box with a question mark in it instead. I can strip the CR's out of the CSV file, but it seems like an unnecessary step. Is there an easy way to get Excel to recognize a CRLF inside a row of a CSV file?
This works for me:
first record,"line one line two",1 second record,only one line,2
In other words, the first record takes up more than one line in the CSV.
It looks like just using
Take a look over at this StackOverflow question.