How to remove special characters in xml

[Former Member]

Dear friends,

How to remove the special character from the xml. I am placing the xml file and fetching through file adapter.

The problem is when there is any special character in xml. i am not able to pass to target system smoothly.

Customer asking schedule the file adapter in order to do that the source xml should not have any special charatcters

How to acheive this friends,

Thanx in advance.

Take care

[Former Member · Accepted solution]

Hi,

What are the spl charcter that you what to remove from source xml.

If your sender adapter is able to process the data then probabily you can handle this during message mapping.

But it will be good if you could provide more details about your scenario and setps that you have done.

Regards,

Sarvesh

[Former Member · Accepted solution]

Hi Sarvesh,

my scenario is as follows:

xml file -

---

> PI 7.0-(Abap Proxies)->BI 7.0

I am fetching source xml file from MDM (syndication server ).It is procees through PI 7.0.while sending the data fronm PI to BI through proxies.

In BI System in sxmb_moni i am getting the error in Request Message Mapping in Runtime(XI Pipline).

I hope Abap proxy not able to tranform the special charcters...

Kindy suggest me what to do.. friends..

Take care

[nisarkhan_n · Accepted solution]

hi

there are some of the common special characters with respect to XML like '&' '>' '<' etc...

you can take care of this replacing with characters which XML understands check this link for more on this...

http://xml.silmaril.ie/authors/specials/

if you have any sepcial characters other than this...let us know.....( you have to find the appropriate XML character and replace it)

[Former Member · Accepted solution]

> xml file -

---

> PI 7.0-(Abap Proxies)->BI 7.0

>

> I am fetching source xml file from MDM (syndication server ).It is procees through PI 7.0.while sending the data fronm PI to BI through proxies.

>

> In BI System in sxmb_moni i am getting the error in Request Message Mapping in Runtime(XI Pipline).

I guess you are getting the error in XI sxmb_moni and not in BI moni, right?

So now to handle the special char, first you have to tell us what are the special char which are causing the problem, because few of the char can be taken care by setting up the correct encoding in your sender adapter while picking the data, and some char as told by Nisar can be taken care during message mapping. So let me know what are the spl char?

Regards,

Sarvesh

[Former Member · Accepted solution]

Dear Sarvesh,

The problem is solved by adding ISO-8859-1 in the Sender File adapter configuration.

Now i have tested with 3 xml files which is having special charcaters. It is reaching the target BI system

successfully.

Thanks a lot friends.

Take care

[Former Member · Accepted solution]

That's what I said in my previous reply that based on spl char you need to set the correct encoding in sender file adapter.

[Former Member]

Hi Karthik,

Go throgh the following links how to handle special character

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

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/502991a2-45d9-2910-d99f-8aba5d79...

Regards

Goli Sridhar