VBScript

Iterate over Direct Children with a Specific Tag

See more XML Examples

Demonstrates how to iterate over direct children having a specific tag.

The input XML, available at http://www.chilkatsoft.com/data/fruit.xml, is this:

<root>
    <fruit color="red">apple</fruit>
    <fruit color="green">pear</fruit>
    <veg color="orange">carrot</veg>
    <meat animal="cow">beef</meat>
    <xyz>
        <fruit color="blue">blueberry</fruit>
        <veg color="green">broccoli</veg>
    </xyz>
    <fruit color="purple">grape</fruit>
    <cheese color="yellow">cheddar</cheese>
</root>

VBScript

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)

success = 0

set xml = CreateObject("Chilkat.Xml")

' The sample input XML is available at http://www.chilkatsoft.com/data/fruit.xml
success = xml.LoadXmlFile("fruit.xml")
If (success <> 1) Then
    outFile.WriteLine(xml.LastErrorText)
    WScript.Quit
End If

'  Get the number of direct children having the tag "fruit"
numWithTag = xml.NumChildrenHavingTag("fruit")

If (numWithTag > 0) Then

    For i = 0 To numWithTag - 1
        ' child is a Chilkat.Xml
        Set child = xml.GetNthChildWithTag("fruit",i)
        outFile.WriteLine(i & ": " & child.Tag & " : " & child.Content)

    Next
    outFile.WriteLine("-----")

    ' Do the same as the above loop, but instead of creating
    ' a new object instance for each child, call GetNthChildWithTag2 to
    ' update the object's reference instead.
    For i = 0 To numWithTag - 1
        ' Navigate to the Nth child.  
        success = xml.GetNthChildWithTag2("fruit",i)
        outFile.WriteLine(i & ": " & xml.Tag & " : " & xml.Content)
        ' Navigate back up to the parent:
        success = xml.GetParent2()
    Next
    outFile.WriteLine("-----")
End If


outFile.Close