Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
9 days, 21 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Sort XML Elements
Posted on 2013-01-02
Having following XML, Want to sort this based on the values in XML elements:
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber>00</HomeNumber
<HouseAddress>PPP Nagar</HouseAddress>
</Address>
<Address>
<HomeNumber>01</HomeNumber
<HouseAddress>Street 145</HouseAddress>
</Address>
<Address>
<HomeNumber>02</HomeNumber
<HouseAddress>Street 798</HouseAddress>
</Address>
Expected Output:
<Address>
<HomeNumber>00</HomeNumber
<HouseAddress>PPP Nagar</HouseAddress>
</Address>
<Address>
<HomeNumber>01</HomeNumber
<HouseAddress>Street 145</HouseAddress>
</Address>
<Address>
<HomeNumber>02</HomeNumber
<HouseAddress>Street 798</HouseAddress>
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
Please suggets. Hopefully looking forward good replies..
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber>00</HomeNumber
<HouseAddress>PPP Nagar</HouseAddress>
</Address>
<Address>
<HomeNumber>01</HomeNumber
<HouseAddress>Street 145</HouseAddress>
</Address>
<Address>
<HomeNumber>02</HomeNumber
<HouseAddress>Street 798</HouseAddress>
</Address>
Expected Output:
<Address>
<HomeNumber>00</HomeNumber
<HouseAddress>PPP Nagar</HouseAddress>
</Address>
<Address>
<HomeNumber>01</HomeNumber
<HouseAddress>Street 145</HouseAddress>
</Address>
<Address>
<HomeNumber>02</HomeNumber
<HouseAddress>Street 798</HouseAddress>
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
<Address>
<HomeNumber />
<HouseAddress />
</Address>
Please suggets. Hopefully looking forward good replies..
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
-
2
6 Comments
see this example will help you
http://stackoverflow.com/questions/716525/how-to-sort-an-xml-file-using-net
http://stackoverflow.com/questions/716525/how-to-sort-an-xml-file-using-net
Active 4 days ago
Thanks for your quick reply,
Would it be possible for you to please provide code for the same... as I am quite newbi.. though I am also trying...
Would it be possible for you to please provide code for the same... as I am quite newbi.. though I am also trying...
Active today
I am puzzled
Your article says
"I have several times needed a way to sort XML, retrieved from a file or a web service, inline without invoking XSL transformations, which is the most common way to do it as I have seen. "
XSLT seems a natural fit to do stuff like this.
All you need is a simple XSLT
Save the XSLT as a file.
Here is an example how you can use the XSLT with the XML
http://blog.garkbit.com/2009-12-14/transforming-xmlxslt-using-net-3-5/
Your article says
"I have several times needed a way to sort XML, retrieved from a file or a web service, inline without invoking XSL transformations, which is the most common way to do it as I have seen. "
XSLT seems a natural fit to do stuff like this.
All you need is a simple XSLT
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:strip-space elements="*"/>
<xsl:output indent="yes"/>
<xsl:template match="root">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="Address[normalize-space(HomeNumber)]">
<xsl:sort select="HomeNumber" data-type="number" order="ascending"/>
</xsl:apply-templates>
<xsl:apply-templates select="Address[not(normalize-space(HomeNumber))]"/>
</xsl:copy>
</xsl:template>
<xsl:template match="Address">
<xsl:copy-of select="."/>
</xsl:template>
</xsl:stylesheet>
Save the XSLT as a file.
Here is an example how you can use the XSLT with the XML
http://blog.garkbit.com/2009-12-14/transforming-xmlxslt-using-net-3-5/
Featured Post
We have some fantastic news for our Android fans. We’re so excited to announce that the Linux Academy Android app is now available with Chromecast support. That’s right – simply download the latest update of the Linux Academy App and start casting your favorite course videos!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Creating an analog clock UserControl seems fairly straight forward. It is, after all, essentially just a circle with several lines in it! Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
(CODE)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month9 days, 21 hours left to enroll
762 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.