Parsing XML Types

Hi,

I'm sort of new to the XML parsing, so trying to work with this. We have a part of the XML document that looks like this:

<KeywordLine xml:lang="en">australia
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">canada
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">earnings
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">electronic+games
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">entertainment
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">europe
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">hardware
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">market
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">massachusetts
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">nyse
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">online
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">software
<Origin AssignedBy="Comtex"/></KeywordLine><KeywordLine xml:lang="en">video
<Origin AssignedBy="Comtex"/></KeywordLine>

I'm interested in extracting out the values as one string space delimited:

australia canada earnings electronic+games entertainment...........

I can run a query using EXTRACT which gets me the entire block above. Is there a way just to extract the value, or need I write something else to parse it? Received on Mon Jul 29 2013 - 19:35:10 CEST