tFileInputPositional out delimited

[Anonymous]

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.

[akumar2301]

Can you please attached one sample inputfile instead.

[Anonymous]

Hi Abhisnek,

Here this InputFile.

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

DummyNames_ForTalend_test.txt

[akumar2301 · Accepted solution]

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

[isari]

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

[akumar2301]

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

Please mark the post as resolved.