I have a csv file, whose columns are enclosed with in double quotes and separated by comma. Also few columns have comma as a value. In my integrations.yml, if I use filter split_by: ‘,’ , it is giving wrong values since some columns has comma inside them as an valid value. I have tried using split_by: ‘","’ or split_by: ‘,"’ , but none of then worked out.
Any help would be appreciated.
What would be split_by filter pattern if csv file has columns enclosed with in double quotes and separated by comma
@nagaraja.arcot Welcome to the community Thank you for being patient with getting a response to your issue. In viewing your account I see you do have access to ticketing support so I’m going to open a ticket so that our team can take a closer look at this with you. Expect an email from them soon!