Parse XML in database

[#1]

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:

IDType	GenderCde	MaritalCde	DateOfBirth	Suburb
ID_SA	Male	Married	1989-02-02T00:00:00	George

Any help on this would be greatly appreciated.

Cheers

[Gysbert_Wassenaar]

That seems to be very tricky. Perhaps these discussions can help you further:

• QlikView 10 SR 4 - FromField Issue when Loading a DB Field with XML Content
• xml data handling with from_field