SFDC CSV file output with comma in the field values issue

[skathiriya]

Hi there,

I am using SFDC object Input metadata connection in the job and output component is tfileoutputdelimited. I'm using comma as a field separator. However, it's not working well when field has a comma value, it's treating one field value with different commas in it as separate columns. Is there a way to fix this?

Thanks.

[TRF]

tFileOutputDelimited Advanced settings + "CSV options" to define the text enclosure

[skathiriya · Accepted solution]

I tried pipe as delimiter and it solved it. Thanks for your suggestion!

[TRF]

À solution as soon as you don't have any pipe in the data!