Read XML by Node Name

itHighway · January 5th, 2010, 01:24 AM

Hello,

How can I read a xml file using Node Names:

For Example:

I could use:

Quote:

objLst.item(i).childNodes.item(2).text

but instead of that, I want something like this:

Quote:

objLst.item(i).childNodes.item("reference").text

Is it possible ? How can i do that ?

Martin Honnen · January 5th, 2010, 01:22 PM

Use selectNodes and/or selectSingleNode which take XPath expressions so e.g.
objLst.item(i).selectSingleNode("reference").text
should do.
Note that with MSXML 3 the default expression language for selectNodes/selectSingleNode is not XPath so you should call
doc.setProperty "SelectionLanguage", "XPath"
(where doc is your MSXML 3 DOM document object) first before using selectNodes or selectSingleNode with XPath expressions.