<snippage> 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. <SNIPPAGE> The problem, as I understand it, is that a TIN means Tax-Payer's Id Number -- and the format tells which type it is. So the xxx-xx-xxxx is an SSN, while xx-xxxxxxx is an "EIN" (Employer's Id Number) which is issued to legal fictions (partnerships, trusts, corps, LLC, etc.) and generally NOT to humans. Given that understanding, a simple set of global changes will only get you into trouble. This will take some intelligence to know the actual format. Now if ALL of these are actually SSNs, then I would assume that you can make the global changes leaving the SSNFormatted values exactly like they are as another poster intimated. Regards, Steve Thompson ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
