Handling Special Character in SAP PI

[Former Member]

Hi,

I have a file to proxy scenario where I have used a complex UDF to get proper data at receiver side.

Now, from the sender side I am getting  some special characters in the files and due to this the whole file is getting failed with mapping error.

Is there any way to handle this thing.

I dont want to use java mapping for this.

Please help

[abhay_aggarwal]

Hi ,

Could you please provide the payload for which you are getting this error.

Regards,

Abhay

[Former Member]

Hi,

The actual payload is very huge -

I am sending you a sample one -

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_InstantData xmlns:ns0="urn:ne.rapdrp.mdas.InstantData">

<Record>

  <Text>00:01:48 23.03.2014,INST_33,FAIL,neamr114700480,114700480,10.11.28.75,,TSEF0469,,,1,, ?  ?,,EHL,INDIA LN 6,DLMS,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,00:00:00 00.01.2800,33,1,,,,,,,,,,,,,,,,,,,,0x2ca7</Text>

  </Record>

</ns0:MT_InstantData>

[anand_shankar10]

The best way seems to be using a UDF which can be used for the particular field mapping.

Thanks

Anand

[Former Member]

Hi Apu,

Please try to change Encoding of file .. It might can help u .

Regards,

Rudra

[Muniyappan]

Hi Apu,

check with sender system if they can get rid of this special chars.

Regards,

Muni.

[former_member184720]

Hi Das - If you know the special char.. you can try using string replace function (if it's coming as part of some field)

else you can try something like suggested in the below thread -

else as you know java mapping would be the other way..

You can refer to the below blog for the same-