Skip to Content
0
May 23, 2012 at 11:21 AM

XML Tags

67 Views

Hi Group,

In PI we are generating the below Output XML file,but our vendor is expecting in differen XML format,can any body suggest how we can conver this in PI:

PI Output

------------------------------

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

<RACTS>

<RACT>

<ACTID>123456789</ACTID>

<NAPM>

<MPANID>7712342</MPANID>

<ATERS>

<ATER>

<RLG>0.15</RLG>

<RUR>0.15</RUR>

<RLI>0.15</RLI>

<ARM>0.15</ARM>

</ATER>

</ATERS>

</NAPM>

<\RACT>

<\RACTS>

Expecting output

-----------------------------

<?xml version="1.0" ?>

<RACTS>

<RACT>

<ACTID="123456789"</ACTID>

<NAPM>

<MPANID="7712342"</MPANID>

<ATERS>

<ATER name="RLG">0.15,</ATER>

<ATER name="RUR">0.15</ATER>

<ATER name="RLI">0.15</ATER>

<ATER name="ARM">0.15</ATER>

</ATERS>

</NAPM>

<\RACT>

<\RACTS>

AlsoIN PI output we are getting we are getting two exta spaces in the first row before "<?xml version="1.0" encoding="UTF-8" ?> ", how to delete that two extra spaces.Pleas can any body help