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

[Nijith]

bellizia_capgemini

Thanks for sharing the groovy script .I was aware of the groovy script approach but was trying to use out of the box converter and see. Thanks a ton once again