Navigating XML nodes in VBScript, for a Dummy

by

Here is a small example:

Suppose you have a file called C:\Temp\Test.xml with this contents:

<?xml version="1.0"?>
<root>
   <property name="alpha" value="1"/>
   <property name="beta" value="2"/>
   <property name="gamma" value="3"/>
</root>

Then you can use this VBScript:

Set objDoc = CreateObject("MSXML.DOMDocument")
objDoc.Load "C:\Temp\Test.xml"

' Iterate over all elements contained in the <root> element:

Set objRoot = objDoc.documentElement
s = ""
t = ""
For Each child in objRoot.childNodes
   s = s & child.getAttribute("name") & " "
   t = t & child.getAttribute("value") & " "
Next
MsgBox s    ' Displays "alpha beta gamma "
MsgBox t    ' Displays "1 2 3 "

' Find a particular element using XPath:

Set objNode = objDoc.selectSingleNode("/root/property[@name="beta"]")
MsgBox objNode.getAttribute("value")     ' Displays 2

I hope this helps getting you started with VBScript and XML.

More Related Contents:

  1. How to use XPath in Python?
  2. How to execute XPath one-liners from shell?
  3. XPath query to get nth instance of an element
  4. Getting attribute using XPath
  5. xmllint failing to properly query with xpath
  6. Xml Namespace breaking my xpath!
  7. XPath to select multiple tags
  8. XPath to select Element by attribute value
  9. How can I use XPath to find the minimum value of an attribute in a set of elements?
  10. XSLT: How to convert XML Node to String
  11. XPath with multiple conditions
  12. How to ignore namespace when selecting XML nodes with XPath
  13. How to find the max attribute from an XML document using Xpath 1.0
  14. Get nodes where child node contains an attribute
  15. XSLT Replace function not found
  16. How do you identify duplicate values in a numerical sequence using XPath 2.0?
  17. What is the difference between ‘or’ and ‘|’ when programming in xslt?
  18. What is the correct XPath for choosing attributes that contain “foo”?
  19. Using XPath, How do I select a node based on its text content and value of an attribute?
  20. XPath to get all child nodes (elements, comments, and text) without parent
  21. How to apply the XPath function ‘substring-after’
  22. XPath to return only elements containing the text, and not its parents
  23. distinct in Xpath?
  24. How can I select an element with multiple classes with Xpath?
  25. WiX Installer: using xslt with heat.exe to update attributes
  26. Traversing all nodes in an XML file with VBScript
  27. XPath find all elements with specific child node
  28. How do I generate a comma-separated list with XSLT/XPath?
  29. Matching a node based on a sibling’s value with XPath
  30. XSLT – Comparing preceding-sibling’s elements with current’s node element

Leave a Comment