VBScript

XML Sort by Tag

See more XML Examples

Demonstrates the SortByTag method.

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

<root>
    <fruits>
        <apple>
            <fuji>blah</fuji>
            <gala>blah</gala>
            <grannySmith>blah</grannySmith>
            <honeycrisp>blah</honeycrisp>
            <mcIntosh>blah</mcIntosh>
        </apple>
        <banana>blah</banana>
        <blackberry>blah</blackberry>
        <blueberry>blah</blueberry>
        <orange>blah</orange>
        <pear>blah</pear>
    </fruits>
</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/fruitSort1.xml
success = xml.LoadXmlFile("fruitSort1.xml")
If (success <> 1) Then
    outFile.WriteLine(xml.LastErrorText)
    WScript.Quit
End If

' Sort the direct children under the "fruits" node by tag:
' xSortRoot is a Chilkat.Xml
Set xSortRoot = xml.FindChild("fruits")

' Sort in ascending order.
bAscending = 1
xSortRoot.SortByTag bAscending

' Show the result:
outFile.WriteLine(xml.GetXml())

' <root>
'     <fruits>
'         <apple>
'             <grannySmith>blah</grannySmith>
'             <gala>blah</gala>
'             <fuji>blah</fuji>
'             <mcIntosh>blah</mcIntosh>
'             <honeycrisp>blah</honeycrisp>
'         </apple>
'         <banana>blah</banana>
'         <blackberry>blah</blackberry>
'         <blueberry>blah</blueberry>
'         <orange>blah</orange>
'         <pear>blah</pear>
'     </fruits>
' </root>

' Sort the direct children under the "apple" node:
success = xSortRoot.FindChild2("apple")

xSortRoot.SortByTag bAscending
outFile.WriteLine(xml.GetXml())

' <root>
'     <fruits>
'         <apple>
'             <fuji>blah</fuji>
'             <gala>blah</gala>
'             <grannySmith>blah</grannySmith>
'             <honeycrisp>blah</honeycrisp>
'             <mcIntosh>blah</mcIntosh>
'         </apple>
'         <banana>blah</banana>
'         <blackberry>blah</blackberry>
'         <blueberry>blah</blueberry>
'         <orange>blah</orange>
'         <pear>blah</pear>
'     </fruits>
' </root>


outFile.Close