BTP CPI - CSV to XML Converter escaping special characters.

[Nijith]

How can I ignore special character in a csv file when using CSV to XML converter component in CPI

E.g. I have a csv file as follows:

EmpId,Name,Address

1,Noel,"Main Street 1,Country Road "

2,Joel,"Main Street 2,Country Road " And when I process the data using the CPI converter it splitting the address into 2 .So is there a way I can escape the , inside the address and get the address as 1 after converting to XML

[bdBais13 · Accepted solution]

I've tested this object with last version:

Input:

Output:

Schema Used:

Object Version used:

Is it similar to your test?

[bdBais13 · Accepted solution]

for xml to xsd I've used: https://www.liquid-technologies.com/online-xml-to-xsd-converter