Translate() function to escape characters in XML
Hi,
We are using OIC version2. We have an integration that gets data from Oracle XML Gateway. One field has data with different characters in it like "|","~","#". We are using translate() function to replace the characters with xml tags to make this xml data.
translate(., "|~#", "</>")
The string is "'|PackingSlip#|PackingSlipNumber#|~PackingSlipNumber#|QuantityReceived#0|~QuantityReceived#|~PackingSlip#'"
The expected output is
<PackingSlip>
<PackingSlipNumber></PackingSlipNumber>
<QuantityReceived>0</QuantityReceived>
</PackingSlip>
But the output being generated is:
<PackingSlip><PackingSlipNumber>test</PackingSlipNumber><QuantityReceived>25</QuantityReceived></PackingSlip>
Can you please point out how I have to specify < so that it shows up as "<" in the output?