topic Re: tFileInputPositional out delimited in Talend Studio

tFileInputPositional out delimited

Anonymous — Wed, 06 Feb 2019 09:28:40 GMT

Hey everyone,

I am having trouble using tFileInputPositional with a tFileOutputDelimited.

I have one .txt file and the looks like this:

The file includes special characters but encoding is UTF-8. And I want delimited this file.

I trying tfileinputpositional ---> tfileoutputdelimited. But I have problem like this:

"Üzeyir;Şaşkın;Bağdat Bulvarı Sözcü Önder Apartmanı No:5;624;443399 Çatala;ğzı İst" ----> The data is not correct.

Why you added semicolon(separator) between the a and ğ? Why it is not like this: çatalağzı;istanbul. I couldn't understand. Please help me.

Data must be like this: "Üzeyir;Şaşkın;Bağdat Bulvarı Sözcü Önder Apartmanı No:5;624443399;Çatalağzı;İstanbul"

Thanks in advance,

Betul B.

Re: tFileInputPositional out delimited

akumar2301 — Wed, 06 Feb 2019 14:20:29 GMT

Can you please attached one sample inputfile instead.

Re: tFileInputPositional out delimited

Anonymous — Wed, 06 Feb 2019 14:26:29 GMT

Hi Abhisnek,

Here this InputFile.

And edit schema(pattern) is "20,20,50,12,16,16"

DummyNames_ForTalend_test.txt

Re: tFileInputPositional out delimited

akumar2301 — Wed, 06 Feb 2019 14:45:53 GMT

1) remove Byte length Cardinality

2) And edit schema(pattern) is "19,19,49,11,15,15"

3) Input and output encoding should be UTF-8

Re: tFileInputPositional out delimited

isari — Wed, 06 Feb 2019 15:48:25 GMT

Greetings Abhishek,

Until today, we had several of our UTF-8 datasets affected from this "byte length cardinality" setting, counting several millions of rows but we didn't know the prime reason...Now thanks to your insight, we can handle those sets with ease... Thank You.

Regards,
Ilke

Re: tFileInputPositional out delimited

akumar2301 — Wed, 06 Feb 2019 15:58:54 GMT

Gr8 , really happy that you could find your solution.
All the best

Please mark the post as resolved.