Subject:Converting csv file with embedded carriage returns Author:Thomas Dorgan Date:08 Jul 2011 08:56 AM
I get a csv file where each field is enclosed in quotes. In the note fields there are embedded carriage returns. Is there any way to get a custom converter to understand that carriage returns in a field do not constitute the end of the record? Excel understands this concept, but the xml converter tool does not. I am attaching a sample of the csv file and the xml created. Please look at this and let me know if there is a solution that I am missing.