topic Re: SFDC CSV file output with comma in the field values issue in Talend Studio

SFDC CSV file output with comma in the field values issue

skathiriya — Thu, 03 Jan 2019 21:58:46 GMT

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.

Re: SFDC CSV file output with comma in the field values issue

TRF — Thu, 03 Jan 2019 22:28:58 GMT

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

Re: SFDC CSV file output with comma in the field values issue

skathiriya — Thu, 03 Jan 2019 22:54:56 GMT

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

Re: SFDC CSV file output with comma in the field values issue

TRF — Fri, 04 Jan 2019 11:15:08 GMT

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