Skip to Content
Former Member
Jun 20, 2010 at 09:26 PM

XML String to XML conversion


Hi Folks,

I have to map an XML string to XML document. I am taking the XML string in to a source field and trying to map that to an XML structure. Sender message will be something like the following

  <?xml version="1.0" encoding="UTF-8" ?> 
- <ns0:mt_edi850 xmlns:ns0="">
- <EDI850>
- <![CDATA[ <POAcknowledgement><ARNumber>0002000017</ARNumber><DocumentType>855</DocumentType><StatusReportDate>06/16/10 15:25:29</StatusReportDate><VendorNumber/><ContractNumber/><DepartmentNumber>DEPARTMENT</DepartmentNumber></POAcknowledgement>


The target message that I would like to map to is as follows

  <?xml version="1.0" encoding="UTF-8" ?> 
- <POAcknowledgement>
  <StatusReportDate>06/16/10 15:25:29</StatusReportDate> 
  <VendorNumber /> 
  <ContractNumber /> 

It is basically unwrapping the XMLdata i,e present in the CDATA tag. Is it possible to achieve the above using graphical mapping if so how, if not what are the other ways to achieve. Please advice.