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?

[gjeremy1617088143]

HI,

in the tFileInputDelimited basic settings , you can check csv options, a new field will appear with csv escape char : """ is selected by default,

it will suppresse all the double quote.

If is not ok could you send some data example

Send me Love and Kudos

[fovo1625813403]

Hi,

It seems it doesn't work. Here some requested data examples

“TB-0-0879-18 STONE’S OEE”

CC P&B (€/unit)

What I see in the tLogRow:

TB-0-0879-18 STONES OEE

CC P&B (/unit)

So all kinds of quotes and currency signs are gone.

[gjeremy1617088143]

have you tried : "ISO-8859-1" if you select CUSTOM in encoding ?

[fovo1625813403]

Yes I tried, but the results were the same

[gjeremy1617088143]

I try with "Cp1252" as CUSTOM ENCODING it works

so you can use tChangeFIleEncoding component with use Custom Input Encoding

as "Cp1252"

and output encoding as UTF-8 for example

it will better for you for the rest of the job € will appear on utf-8 now

[fovo1625813403]

This is my result

[gjeremy1617088143]

could you open it via notepad and look wich encoding you have ?

[fovo1625813403]

ANSI

[gjeremy1617088143]

could you send me the file but with just one or two lines ?