Note: As it stands that ISN'T valid XML. I assume it's a subset of your actual file else standard XML processing is barking up the wrong tree. :-(
Others have answered how to do the transformation of what you've shown to what you want. Cheers, Martin Martin Packer, Mainframe Performance Consultant, zChampion Worldwide Banking Center of Excellence, IBM +44-7802-245-584 email: [email protected] Twitter / Facebook IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Ron Thomas <[email protected]> To: [email protected], Date: 30/04/2012 18:13 Subject: XML Parsing Sent by: IBM Mainframe Discussion List <[email protected]> Hi , We have XML file that is send by the customer, we need to alter the XML file and send it back to 3'rd party . Here is the xml file <SSN>123604299</SSN>.. <SSNFormatted>123-60-4299</SSNFormatted> The altered format need to be like the one below <TIN>123604399</TIN>.. The SSNFormatted tag is removed & TIN is the one we need to send across to the 3'rd party. I would like get from the listners how we can acheive the same. Thanks, Ron T ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN

