How to sort based on different nodes?

Question

I need to sort my tags in a XML file based on multiple different nodes. For example: Consider the following XML:

<root>
    <a>
        <b>12</b>
        <e>hello</e>
    </a> 
    <a>
        <b>11</b>
        <e>how</e>
    </a>
    <a>
        <c>13</c>
        <f>are</f>
    </a>
    <a>
        <b>21</b>
        <f>you</f>
    </a>
    <a>
        <d>22</d>
        <e>hello</e>
    </a>
    <a>
        <c>14</c>
        <f>hi</f>
    </a>
</root>

Now I need to find the maximum number from inside all the nodes inside a. I tried doing this:

<xsl:template match="root">
    <xsl:for-each select="a">
        <xsl:sort select="b | c | d" data-type="number" order="descending"/>   <!-- this gives me error-->
            <xsl:if test="position() = 1">
                <!-- how to access my node -->
            </xsl:if>
    </xsl:for-each>
</xsl:template>

How can I do my sorting and get the value form the first node after sorting?

Thnx in advance!!

Note: I am using XSLT 1.0.

what is your required output? Please see my answer below. Should you have a different requirement, feel free to edit your post. — Joel M. Lamsen
– Joel M. Lamsen, Commented Mar 24, 2014 at 6:23
@JoelM.Lamsen structure of the output is not important. I just need the maximum value. — Surender Thakran
– Surender Thakran, Commented Mar 24, 2014 at 6:27

Joel M. Lamsen · Accepted Answer · 2014-03-24 06:51:55Z

2

This stylesheet:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    version="1.0">
    <xsl:output indent="yes" omit-xml-declaration="yes"/>

    <xsl:template match="root">
        <xsl:for-each select="a/*[string(number(.))!='NaN']">
            <xsl:sort select="." order="descending"/>
            <xsl:if test="position() = 1">
                <highest><xsl:copy-of select="."/></highest>
            </xsl:if>
        </xsl:for-each>
    </xsl:template>

</xsl:stylesheet>

when applied to the edited input XML above, outputs

<highest>
   <d>22</d>
</highest>

edited Mar 24, 2014 at 6:51

answered Mar 24, 2014 at 6:21

Joel M. Lamsen

7,1911 gold badge14 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Surender Thakran Over a year ago

plz see the updated XML. The nodes inside a may not always be nodes containing numbers. Other types of node may also be present.

Joel M. Lamsen Over a year ago

I have edited my post. Please check if this suits your requirement.

Surender Thakran Over a year ago

yes, after tweaking the idea a little according to my XML I can use your solution. thank you very much.

Surender Thakran Over a year ago

what if i have to process the numbers before sorting them. For example, in the above xml the numbers had some units associated with them like m, cm, in etc. Now first I have to transform all of them in a single unit like cm and then sort them. How can I do that?

Joel M. Lamsen Over a year ago

please post this as another question.

|

Collectives™ on Stack Overflow

How to sort based on different nodes?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related