Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

CSV to XML with extra commas


I'm importing a CSV to XML using text loader and Flat File Parser, then using StringListToXML parser on each line of my input.

This has delimeter set to "," and strip quotes=true.

My problem is it doesn't seem to be able to handle it when some of the values have embedded quotes, so for example


which should come out as





actually comes out as






Any Ideas? I have no control over the source CSV.

Remember if you are trying this you'll have to escape the quotes in the "Input" of the parser, thus "\"1\",\"abc\",\"abc,def\",\"blah\""




xMII version 11.5.3 b66

Server Plug in 1.4.2_06 build b03

Client Plug in 1.6.0_02



Try setting the Delimeter to:

doublequote & ","

Hope this helps.


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question