Skip to Content
avatar image
Former Member

Pound Sign (u00A3) in Sender SFTP Channel - using MessageTransormBean

Hi,

I am reading a csv file using Seeburger SFTP Sender Communication channel.

One of the field has pound sign like £250 forTution

With default UTF-8 codepage I am geting a square symbol instead of £ sign.

I tried to set codepage to ISO-8859-1 and windows-1252 and other UTF code pages using MessageTransformBean's Transform.ContentType = text/xml;charset=ISO-8859-1

They are giving some other special characters for £ sign.

What is the correct code page we should use to read £ sign correctly into payload. Any suggestions are greatly appreciated.

Regards,

Ramesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 03, 2010 at 02:23 PM

    > I tried to set codepage to ISO-8859-1 and windows-1252 and other UTF code pages using MessageTransformBean's Transform.ContentType = text/xml;charset=ISO-8859-1

    The Transform.ContentType is the target code page, so it does not make sense to use ISO-8859-1 here.

    Put the code page in the processing part of the communication channel, use file type = text, file encoding = ISO-8859-1

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Stefan Grube

      Thank you Stefan! That helped me too. I have only one additional remark.

      My problem was that this solution didn’t work at the beginning because the line

      Plain2XML Transform.Class com.sap.aii.messaging.adapter.Conversion

      was always the first line. Every time I tried to put the ContentType line in the first row it becomes the second after saving.  So I’ve done the following trick. I added the MessageTransformBean twice with the names Plain2XML_Step1 and Plain2XML_Step2 (in this order). In the module configuration part I added the following three lines:

      Plain2XML_Step1 Transform.ContentType text/plain;charset=iso-8859-1

      Plain2XML_Step2 Transform.Class com.sap.aii.messaging.adapter.Conversion

      Plain2XML_Step2 Transform.ContentType text/xml;charset=utf-8