SFDC CSV file output with comma in the field values issue

Highlighted
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
Fifteen Stars TRF
Fifteen 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!
Fifteen Stars TRF
Fifteen 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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download