I need to add double quotation to a column which will be exported into a csv.
I just saw that the component tFileOutDelimited has an option for text enclosure but there I can't
select the right column it will put double quotes on all my column values.
Let's say the column is called product description.
The string is something like: abc wheel size 16"
Which component do I need that the csv will show "abc wheel 16" "?
Do I have to replace the double quote on 16 inside the string so that a csv parser is able to know that this is not the end of the string?
Thanks for any tips.
We can use StringHandling.DQUOTE("Hello") function in talend to put double quotation for a string.
Nice but what about the double quote inside a string? Will it be escaped?
Inside the csv I need this pattern e.g. wheel size 24"" that the parser is able to convert it into: wheel size 24"
I took this as an example:
1,TITU,Titu wheel size 16"
and pass this to tFileOutputDelimited as FilName.csv with field separator ",".
After running the job, it will show the record as it is (TITU,Titu wheel size 16") with double quotes at the end.
No need to use CSV option in AdvanceSettings.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema