Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That seems to be very tricky. Perhaps these discussions can help you further: