Transform file in ANSI format using SFTP

[Former Member]

Hi All,

We are using SFTP and are required to convert the file to ANSI format and do a PGP encryption. The third receives the file in ANSI format decrypts it and it should remain ANSI.

We are using below in the Module parameter:

Module Key - Encode

Parameter Name - Transform.ContentType

Parameter Value - text/plain;charset=ISO-8859-1

When the source contains special characters like "é", then the SFTP module converting file into utf-8.

Please help to let me know how can we can handle such special characters.

Thanks,

Vinod

[Former Member]

Hello Vinod ,

Can you please check the note 1906648  and try setting the File Encoding to the one you need.

Regards,

Malini

[former_member184720]

Hi Vinod - As it is not part of the charset ISO-8859-1, PI converts into UTF-8.

May be you can remove special char and set the encoding using a java mapping.

Check the below blog for the java code

http://scn.sap.com/docs/DOC-46151

[Former Member]

Hi Hareesh,

The ‘e acute’ character é is in the ISO-8859-1. It’s reference number is 233 (Hex reference 0xE9). For reference it’s also available for Unicode/UTF-8 encoding with reference (U+00E9).

Please refer the below link for your reference:

ISO/IEC 8859-1 - Wikipedia, the free encyclopedia

Thanks,

Vinod

[former_member184720]

Sorry that was my bad and thanks Vinod for correcting.

Can you check the reply from Rafael Trübswasserin the below thread if that helps?

[Former Member]

Hi All,

Is their any tool to check file type manually. Till now i am refering an online tool which is only tell file is in ASCII format or utf-8 format.

CheckFileType.com - Free Online File Type Checker

I need a tool which will identify that the file is ANSI format or not.

Thanks,

Vinod

[former_member184720]

Did you try notepad++ ?? - I use it for many things but never knew of it

http://programmers.stackexchange.com/questions/187169/how-to-detect-the-encoding-of-a-file