using max() function XPath

Question

I have a problem on how to use max() function on XPath,

If consider following xml, I need to select the <tr> element which has maximum number of child <td> in it.

<doc>
    <table>
        <tbody>
            <tr>
                <td>aa</td>
                <td>bb</td>
                <td>cc</td>
                <td>dd</td>
            </tr>
            <tr>
                <td>nn</td>
                <td>oo</td>
            </tr>
            <tr>
                <td>qq</td>
                <td>rr</td>
                <td>ss</td>
                <td>tt</td>
                <td>uu</td>
                <td>vv</td>
                <td>xx</td>
                <td>yy</td>
                <td>zz</td>
            </tr>
        </tbody>
    </table>
</doc>

SO I wrote following xpath query

tr[max(count(child::td))]

But it return no result. can anyone suggest me a query that I can get <tr> which has maximum number of child <td>s ?

What should happen if multiple trs have the same number of tds (and that is the maximum)? — Damien_The_Unbeliever
– Damien_The_Unbeliever, Commented Oct 6, 2015 at 7:42
@Damien_The_Unbeliever , then the both <tr> should be selected — sanjay
– sanjay, Commented Oct 6, 2015 at 7:48

Damien_The_Unbeliever · Accepted Answer · 2015-10-06 07:55:05Z

2

I think that this expression gives you what you want:

//tr[count(./td)>=count(following-sibling::tr/td) and
     count(./td)>=count(preceding-sibling::tr/td)]

That is, we want the count of the current nodes tds to be greater or equal to the count of any preceding node's tds and any following nodes tds.

You may want to adjust the starting point (I just went for any tr by starting with //) and depending on the relationships required, the sibling axes might need to be change to plain following and preceding.

answered Oct 6, 2015 at 7:55

Damien_The_Unbeliever

241k28 gold badges358 silver badges470 bronze badges

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

Collectives™ on Stack Overflow

using max() function XPath

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related