Parsing CDATA section...HELP please!



In VB I need to write some logic to make a call to a website and parse the
return data which is in XML CDATA sections. Can anybody provide some hint as
to how this might be done? Below is an incomplete sample of the XML:

The CDATA sections I need reside in <RECORDS><COLS><COL> tag.

TIA

Alex-

============SAMPLE XML====================
<?xml version="1.0" encoding="ISO-8859-1" ?>
- <DME>
- <CGIBASE>
- <DMEBASE executable="/cgi-lawson/dme.exe">
- <![CDATA[
PROD=QAS&FILE=APVENMAST&INDEX=VENSET5&KEY=FDVG&COND=ACTIVE%2DVENDOR&FIELD=VENDOR%2DSNAME;VENDOR&SELECT=VENDOR%2DSNAME%7EAPC&MAX=600&OUT=XML&DELIM=%09&NOHEADER&
]]>
</DMEBASE>
- <IDABASE executable="/cgi-lawson/ida.exe">
- <![CDATA[ _TYP=OS&_PDL=QAS&_FN=APVENMAST&_IN=VENSET5&_OUT=XML&
]]>
</IDABASE>
</CGIBASE>
- <KEYS>
<KEY name="Vendor-group" type="ALPHA" size="4" />
<KEY name="Vendor-sname" type="ALPHA" size="30" />
<KEY name="Vendor" type="ALPHARIGHT" size="9" />
</KEYS>
- <COLUMNS>
<COLUMN header="Vendor_Sname" dspname="Search Name" type="ALPHA" size="30"
/>
<COLUMN header="Vendor" dspname="Vendor" type="ALPHARIGHT" size="9" />
</COLUMNS>
- <RECORDS count="15">
- <RECORD>
- <RECKEY>
- <![CDATA[ =FDVG=APC=++++34643
]]>
</RECKEY>
- <COLS>
- <COL>
- <![CDATA[ APC
]]>
</COL>
- <COL>
- <![CDATA[ 34643
]]>
</COL>
</COLS>
- <IDACALL>
- <![CDATA[ K1=FDVG&K2=APC&K3=++++34643
]]>
=================End Sample======================
.



Relevant Pages