AnsweredAssumed Answered

Data parsing Issue with Flat file having double quotes &comma in specific row

Question asked by vinay.devarapalli689108 on Jun 8, 2018
Latest reply on Jun 11, 2018 by britto.parthalomew

Hi

I have the issue with flat file data parsing issue.

I use to get source file having a row value for one column was "Integration,Dell Boomi"  due to having double quotes and comma it splits after a comma as sperate row .

the source looks like:

When passing this to Boomi CSV profile it results split after a comma and Dell Boomi moves to next row

"Name","Description"

"Dell Boomi","Integration"

"Netsuite","Integration","Dell Boomi"""

 

Can you help how to handle this case in csv profile

Outcomes