tFileInputDelimited cannot read currency signs

[fovo1625813403]

Hi all,

I am using a tFileInputDelimited to read a csv-file, but with a tLogRow I can see certain signs are not read correctly. For example currency signs as well as quotes. I saw you can change the encoding of the input, but that doesn't solve the problem.

Does anyone know how this can be solved?

[fovo1625813403]

Sure!

[gjeremy1617088143]

cause if Cp1252 doesn't work for ANSi, i have to find the specific one ENCODING

[fovo1625813403]

I hope you can find it

[gjeremy1617088143]

here the result with cp1252 :

currency is ok

there is special char that are not double quote but Modifier Letter Double Apostrophe

[fovo1625813403]

I don't know why but I cannot manage to see the currency with cp1252 as I said earlier. Any idea what the reason could be?

[gjeremy1617088143]

you can try to add

-Dfile.encoding=UTF8

in your jvm parameters :

Run Tab -->Advanced sttings --> use specific JVM arguments --> new

[fovo1625813403]

Unfortunately the same results...

[gjeremy1617088143]

Hi ,your file is encoded in windows- 1250 , so it's "Cp1250"

[fovo1625813403]

Somehow I fixed it with CP1252. tLogRow doesn't show what I want to see, but when I write it to a database or tFileOutput everything seems to be OK.

Anyway, thanks for your help

[gjeremy1617088143]

Hi, i'm happy you succeed !

if one of my answer set you on the right path please select it as the best answer.

Send me Love and Kudos