Handling special characters

[Former Member]

We are successfully sending special characters from SAP ECC to PI and from PI to target system but it is getting rejected by the target system.

We are using UTF-8 encoding in PI and we have no issues in PI.

Client , target system is asking to remove all special charcaters in mapping

I am using a udf code but it's not possible to list the special characters and suppress them

Is it better to allow only some characters ike A to Z and 0 to 9 in mapping?

How do I do this ? The best option

[former_member669282]

Try below link

Remove non-UTF-8 Characters

[stefan_grube]

First of all, you should ask the client, what exactly is a special character and why does it cause errors. The message is different when you remove characters, information might lack.

Maybe it is a code page issue.

[RaghuVamseedhar]

Midhun,

I would suggest to investigate, why target system is rejecting file and what characters it is rejecting?

If target system wants only Latin alphabets use Cp1252 as encoding in receiver channel.

Windows-1252 - Wikipedia

[praveen_sutra]

Hi Midhun,

You can use java mapping to handle this scenario..

Hope this helps.

thanks and regards,

Praveen T

[azharshaikh]

Hi Midhun,

Please check if the following link helps:

Suppressing the spl chars wud lead to loss of data

Regards,

Azhar