Parsing CDATA section...HELP please!
- From: "Alex Wolff" <AlexWolff@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Aug 2005 10:09:02 -0700
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======================
.
- Follow-Ups:
- Re: Parsing CDATA section...HELP please!
- From: Mike D Sutton
- Re: Parsing CDATA section...HELP please!
- From: alpine
- Re: Parsing CDATA section...HELP please!
- Prev by Date: Re: How to speed up this process
- Next by Date: execute existing dial up win xp dial-up connection from vb
- Previous by thread: PDF generation and Outlook automation error
- Next by thread: Re: Parsing CDATA section...HELP please!
- Index(es):
Relevant Pages
|