Subject:problem converting CSV to XML Author:edmond azaryan Date:19 Jan 2007 05:00 PM
I am fairly new to this so I apologise if this is a stupid question.
I am trying to convert a CSV file to XML format. Everything is fine except one of the coloums I have in the CSV file has multiple rows of text. I do not know what I need to check when converting to make sure that the text falls under the correct coloumn, because now only the first line falls under the correct coloumn. I have attached the file to this messege, the name of the coloumn is called "DETAILS" any suggestions would be greatly appreciated.
Subject:problem converting CSV to XML Author:Tony Lavinio Date:01 Feb 2007 02:56 PM
You cannot do this with the CSV adapter, but you can with the
Convert-to-XML adapter, which can distinguish between the LF
that is used inside of the quoted string to break lines, and
the CRLF that is used to split records.