topic Re: Adding a header to an output file with double quotes. in Talend Studio

Adding a header to an output file with double quotes.

Anonymous — Fri, 04 Apr 2014 09:43:56 GMT

Hi Guys,
I hope you can help me with this.
I need to be able to put " around my header in a tFileOutputDelimited file for load.
When I read it (intFileInputDelimited) it looks likes this:
"Key","Item","Data"
"1", "Milk", "Bottle"

I need it in the exact same format in the tFileOutputDelimited after some manipulation but what I am seeing is:
Key,Item,Data
"1", "Milk", "Bottle"
Is there any easy way of doing this apart from splitting them about merging back together.
Second problem is, Ive tried to split them and use tUnite which works if I had only one file.
But since I need to read in a bunch of files and add the same header I cannot get it to work.
I am using a tFileList - intFileInputDelimited and tUnite to a static intFileInputDelimited file(header) but it seems to be in a loop of some sort. I expect Im missing a component but dont know what.
Thanks,
Adrian.

Re: Adding a header to an output file with double quotes.

janhess — Fri, 04 Apr 2014 16:35:12 GMT

Have you tried treating the header as data?

Re: Adding a header to an output file with double quotes.

Anonymous — Thu, 17 Apr 2014 16:53:00 GMT

Yes but I had some transformation to do so I couldnt use that. In the end, my problem was with the header in that Talend converted - to _ when reading the metadata to create the header so i had to change accordingly.

Re: Adding a header to an output file with double quotes.

Anonymous — Fri, 18 Apr 2014 05:46:42 GMT

Yes, reason being, Talend converts all the special characters in the input metadata to "_". It makes sense to have column names in double quotes when there is an option to have data in double quotes. But how?

Re: Adding a header to an output file with double quotes.

Anonymous — Fri, 18 Apr 2014 18:43:03 GMT

It's not elegant but why not write your headers separately.
Create a String with your quotes headers and write this to your file.
Then append your data but without headers.