Special Chars in XML input

[#1]

Hi Guru's,

I am doing a FIle(XML) to Proxy scenario. Unfortunately the file sent by 3rd party system contains some special chars like "&".

Here is what I get into XI. <Program>FY08 Pilsner - National Media & Fees</Program>. When I manually change it to <Program><![CDATA[FY08 Pilsner - National Media & Fees]]></Program> it works.

After reading some of the forum threads I came to know that we can do this using JAVA mapping before doing the actual graphical mapping. I need to what exactly I should be doing in JAVA mapping and I need some sample JAVA mapping code if somebody has already implemented this solution.

Thanks.

Srini Vaidyam

[Former Member]

Vaidyam,

I dont think it will create a problem. That should be fine. Can you paste the whole payload here.

Regards,

---Satish

[Former Member]

The "&" create problem in my graphical mapping.

Here is the payload

<Report xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="file:///C:/Trandev50/models/MyModels/XSDFINAL.xsd"><Data>

<Row>

<Month>1</Month>

<Year>2008</Year>

<IncBrand>UR</IncBrand>

<MktArea></MktArea>

<MediaType>110</MediaType>

<PlanAmt>45704.5</PlanAmt>

<Program>FY08 Pilsner - National Media & Fees</Program>

</Row>

<Row>

<Month>2</Month>

<Year>2008</Year>

<IncBrand>UR</IncBrand>

<MktArea></MktArea>

<MediaType>110</MediaType>

<PlanAmt>25134.5</PlanAmt>

<Program>FY08 Pilsner - National Media & Fees</Program>

</Row>

<Row>

<Month>3</Month>

<Year>2008</Year>

<IncBrand>UR</IncBrand>

<MktArea></MktArea>

<MediaType>110</MediaType>

<PlanAmt>22316</PlanAmt>

<Program>FY08 Pilsner - National Media & Fees</Program>

</Row>

</Data>

</Report>