PowerBuilder

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>

PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Xml
oleobject loo_XSortRoot
integer li_BAscending

li_Success = 0

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")
if li_rc < 0 then
    destroy loo_Xml
    MessageBox("Error","Connecting to COM object failed")
    return
end if

// The sample input XML is available at http://www.chilkatsoft.com/data/fruitSort1.xml
li_Success = loo_Xml.LoadXmlFile("fruitSort1.xml")
if li_Success <> 1 then
    Write-Debug loo_Xml.LastErrorText
    destroy loo_Xml
    return
end if

// Sort the direct children under the "fruits" node by tag:
loo_XSortRoot = loo_Xml.FindChild("fruits")

// Sort in ascending order.
li_BAscending = 1
loo_XSortRoot.SortByTag(li_BAscending)

// Show the result:
Write-Debug loo_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:
li_Success = loo_XSortRoot.FindChild2("apple")

loo_XSortRoot.SortByTag(li_BAscending)
Write-Debug loo_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>

destroy loo_XSortRoot


destroy loo_Xml