Suppose I input file with data below (1st row as header)
I am expecting the output to have value as below
Output file data :-
Whereever we have some value in a field ,it should be within double quotes (""). If no value is present in that field then no double quotes required. Fields are separated by |.
I am not able to do this using Text Enclosure under CSV option of tfileOutputDelimited.
You need an additional subjob to rework the outputfile after it has been produced with your actual tFileOutputDelimited.
In this new subjob, read the file with a tFileInputInputFullRow then in a tMap replace all the "" with the following expression:
Then rewrite the output file with another tFileOutputDelimited component.
check csv options
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Take a look at this technical overview video of Talend API Designer
Find out how to get started with APIs