Re: parse xml alternative ways

2008-07-30 Thread Joerg Arand
You own parser? Find in a do while loop with ATCatc('section id=production.shipping',lcXML) all needet sections and extract them. lcXML= your_xmlString Lnstart=atc('section id=production.shipping',lcXML) lni=1 Do While Lnstart#0 .. find end of this section and extract the value

Antw: parse xml alternative ways

2008-07-30 Thread Joerg Arand
You own parser? Find in a do while loop with ATCatc('section id=production.shipping',lcXML) all needet sections and extract them. lcXML= your_xmlString Lnstart=atc('section id=production.shipping',lcXML) lni=1 Do While Lnstart#0 .. find end of this section and extract the value

RE: parse xml alternative ways

2008-07-30 Thread Sietse Wijnker
Joerg Arand Verzonden: woensdag 30 juli 2008 10:12 Aan: [EMAIL PROTECTED] Onderwerp: Re: parse xml alternative ways You own parser? Find in a do while loop with ATCatc('section id=production.shipping',lcXML) all needet sections and extract them. lcXML= your_xmlString Lnstart=atc('section id

Re: parse xml alternative ways

2008-07-30 Thread Stephen Russell
On Thu, Jul 31, 2008 at 3:46 PM, Francis I. Coppage, Jr. [EMAIL PROTECTED] wrote: Would XMLTOCURSOR() and a SQL-Select work? JMTC - No that data is pulled from a single column in a table, so you would consider it just a string at starting point. -- Stephen

Re: parse xml alternative ways

2008-07-30 Thread Stephen Russell
On Wed, Jul 30, 2008 at 4:15 AM, Sietse Wijnker [EMAIL PROTECTED] wrote: Why not use STREXTRACT()? Following code loops through all section-node id's in the specialInstruction-node Then for each found ID it retrieves the node value and the calls the FoundValue function (Code is not tested,

RE: parse xml alternative ways

2008-07-30 Thread Sietse Wijnker
Actually not really. My code offers you the possibility to react to each section, where yours only gives the 1st node. For exactly matching your example: cValue = STREXTRACT(cXML, [section id=production.shipping], [/section],1,1) cValue will be empty if the xml node doesn't exist or actually is

Re: parse xml alternative ways

2008-07-30 Thread Stephen Russell
On Wed, Jul 30, 2008 at 2:51 PM, Sietse Wijnker [EMAIL PROTECTED] wrote: Actually not really. My code offers you the possibility to react to each section, where yours only gives the 1st node. For exactly matching your example: cValue = STREXTRACT(cXML, [section id=production.shipping],

parse xml alternative ways

2008-07-29 Thread Stephen Russell
I have a column in a table that is like a vfp memo. I have XML data stored there that will pull off and use all over the place in our apps. I have to identify there is any value in the production.shipping attribute. XML data looks like so: specialInstruction section

RE: parse xml alternative ways

2008-07-29 Thread Francis I. Coppage, Jr.
Russell Sent: Tuesday, July 29, 2008 9:30 AM To: [EMAIL PROTECTED] Subject: parse xml alternative ways I have a column in a table that is like a vfp memo. I have XML data stored there that will pull off and use all over the place in our apps. I have to identify there is any value