search xml file for text between two tags

What's the best way to go about searching an external xml file for the text between two tags and assigning that text to a string? Some of these xml files can get rather lengthy and I'm trying to figure out the most efficient way possible.

Thanks! :D

What language will you be using?

Visual Basic...

lets say you have an xml doc myxmldoc.xml that looks like this

Code:

---

<blah>
  <test>hiya</test>
</blah>

---

to get the text in test:

Code:

---

Dim xmlDoc As MSXML.DOMDocument
Dim xmltext as string
Set xmlDoc = New MSXML.DOMDocument
xmlDoc.async = False
xmlDoc.load "c:\myxmldoc.xml"
xmltext = xmlDoc.selectSingleNode("blah/test").text

---

I'm using XSLT on this XML file as well.... How would you apply a XSL transformation to the example you provided?

Thanks for the help. Your explanation makes good sense.

Tom
www.blazerowners.com
Chevy Blazer Owner's Club