parsing the tags out of an XML file

[adventuresofgreg]

Hello: What is the fastest way to parse out these XML tags from some futures price data?

<Date>11/3/2010</Date>
<Open>1197.5</Open>
<High>1198</High>
<Low>1196</Low>
<Last>1197.25</Last>
<Settle>1197.25</Settle>
<Volume>2361808</Volume>
<OpenInterest>2683550</OpenInterest>

It would be cool if you could set the itemdelimiter to an entire string rather than just one character - like in this case, if I could set the item delimiter to <anything>, then just replace all the item delimiters with ","'s

[Mark]

adventuresofgreg,

Let's assume that fld 2 contains your XML...

Code: Select all

on mouseUp
     put "<p>" & fld 2 & "</p>" into myHtml
     replace cr with "</p><p>" in myHtml
     set the htmlText of fld 1 to myHtml
end mouseUp

Kind regards,

Mark

[adventuresofgreg]

wow - thanks Mark! That's so simple - and fast. Now I just have to try to understand it... I'll look up htmlText. I want to convert each date of prices to the standard:

date,prices,return
date, prices, return
etc...

adventuresofgreg,

Let's assume that fld 2 contains your XML...

Code: Select all

on mouseUp
     put "<p>" & fld 2 & "</p>" into myHtml
     replace cr with "</p><p>" in myHtml
     set the htmlText of fld 1 to myHtml
end mouseUp

Kind regards,

Mark

[Klaus]

Hi Greg,

looks like you need to dive a bit deeper into XML
Of course you could do some chunk stuff within a repeat loop,
but to be prepared for the future you should take the dive!

Please check the wonderful stack "xmldemo1" on this site:
http://www.troz.net/rev/
This got me started with XML, too!


Best

Klaus