topic Re: File delimited using tabulation field separator - problem in tMap in Talend Studio

File delimited using tabulation field separator - problem in tMap

Anonymous — Sat, 16 Nov 2024 13:17:57 GMT

Hello,
I have a tMap which map a .txt delimited file and a metadata table.
In the tMap, all the fields in the delimited file is displayed as a single line. Please see the image of the tMap.
I tried to check "trim all column" in the file advanced settings, but it still doesn't give me each field in separate line.
I have no problem with the csv file, but the .txt file
Thank you very much for your help.

Re: File delimited using tabulation field separator - problem in tMap

janhess — Wed, 01 Sep 2010 16:40:48 GMT

in tFileInputDelimited set the delimiter to "\t"

Re: File delimited using tabulation field separator - problem in tMap

Anonymous — Wed, 01 Sep 2010 17:46:01 GMT

Hi there,
I did set the delimiter to "\t" as in the attached image, and I don't get it works.
Thanks.

Re: File delimited using tabulation field separator - problem in tMap

Anonymous — Thu, 02 Sep 2010 09:34:27 GMT

Hi
First of all your txt file, does it have , or ; when seperating the fields together. What do you get when you click the preview button.
Could you show me a clip of it and i insist you. I also had a problem with the txt files but managed to sort it out though.

Re: File delimited using tabulation field separator - problem in tMap

Anonymous — Fri, 03 Sep 2010 14:37:27 GMT

Hello,
The .txt file doesn't have , or ; It is tab.
Please see the image for the file format when I click on the preview.
Thanks very much for your help.

Re: File delimited using tabulation field separator - problem in tMap

janhess — Mon, 06 Sep 2010 11:51:42 GMT

What does the data look like?
There's no output in your tMap
There's no join between the 2 inputs. Is that correct.