1 Reply Latest reply: Apr 25, 2014 1:04 PM by Gysbert Wassenaar RSS

    Parse XML in database

      Hi there,

       

      I'm currently faced with a situation where I have XML data stored as a string in a database.  An example of what this data looks like:

       

      <?xml version="1.0" encoding="utf-16"?>  <Quote xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">     <IDType>ID_SA</IDType>      <IDNumber />      <GenderCde>Male</GenderCde>      <MaritalCde>Married</MaritalCde>      <DateOfBirth>1989-02-02T00:00:00</DateOfBirth>        <Suburb>GEORGE</Suburb>  </Quote>

       

      Is there any straightforward way to parse this in the load script such that, for the above, I'd end up with:

       

      IDTypeGenderCdeMaritalCdeDateOfBirthSuburb
      ID_SAMaleMarried1989-02-02T00:00:00George

       

      Any help on this would be greatly appreciated.

       

      Cheers