Looking for code page solution in File-Adapter

[Former Member]

Hi,

we have File2IDoc Scenario and we have to read a csv-file with File/FTP-Adapter.

Because there are some german umlaut in the text (like ä,ü,ö) these letters are not well read from adapter. Therefore i changed file-coding to ISO-8859-1, UTF-8, US-ASCII and so on but i got ASCII-Strings like square for a 'ü' etc.

Does somebody has an idea how i can solve this even when i declare the codepages in adapter?!

br

[stefan_grube]

First of all you have to figure out which encoding the file has. You can use a hex editor, another option is to open the file with internet explorer and choose view -> encoding to select an encoding where the letters are displayed correctly.

Put this encoding in the file channel and check in SXMB_MONI if it is displayed right.

Usually the file is ISO-8859-1, but it could have other encodings as well, for example EBCDIC 273

Hope that helps

Stefan

[Former Member]

Hi, finally i figuerd out what causes the problem of getting "wrong" letters.

Because the source file is generated from a DOS-Tool we get OEM-Standard. The Windows-FTP where we get the file from interprets this OEM wrong, Windows only understands ANSI.

Therefore you have to transfrom the file from OEM to ANSI.

That's it and it works...so far.

br, thx to all of you!

[aashish_sinha]

Hi,

Have a look into this blog.. its recent sensation :)..

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/9420 [original link is broken] [original link is broken] [original link is broken]

Regards

Aashish Sinha

PS : reward points if helpful

[GabrielSagaya]

Hi,

please use the encoding as ISO-8859-5 instead of ISO-8859-1, UTF-8

[Former Member]

Hi, thx for your support.

I tried and read like all of you suggested but nothing worked out.

Well i already get this stuff from file:

"St[square]ckz."

where square can't be shown here

i have no idea how to convert this.

br

[former_member859847]

Hi,

Please check the following thread.

regards

mahesh.

[Former Member]

Hi,

Use one of the following encoding.

Try with ISO 8859 encoding in file adapter.

http://en.wikipedia.org/wiki/ISO/IEC_8859

chirag

[former_member859847]

Hi,

Please use the file encoding as ISO-8859-1.

regards

mahesh.