SFDC CSV file output with comma in the field values issue

Five Stars

SFDC CSV file output with comma in the field values issue

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.


Accepted Solutions
Five Stars

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

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

All Replies
Forteen Stars TRF
Forteen Stars

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

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

TRF
Five Stars

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

I tried pipe as delimiter and it solved it. Thanks for your suggestion!
Highlighted
Forteen Stars TRF
Forteen Stars

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

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

TRF

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.