Subject: Re: sorting a table based on first column which contains both numbers and words
From: Andrew Welch <andrew.j.welch@xxxxxxxxx>
Date: Thu, 17 Dec 2009 15:27:53 +0000
|
2009/12/17 Robby Pelssers <robby.pelssers@xxxxxxxxx>:
> Hi all,
>
> I have the use case where I need to sort a table based on it's first
column. This column can contain only numbers but also a mix of words and
numbers. See example below.
>
> <table>
> <tr>
> <td>5</td>
> </tr>
> <tr>
> <td>3</td>
> </tr>
> <tr>
> <td>Banana</td>
> </tr>
> <tr>
> <td>Apple</td>
> </tr>
> </table>
>
>
> I want following output (first sorted numerical and then alphabetically)
>
> <table>
> <tr>
> <td>3</td>
> </tr>
> <tr>
> <td>5</td>
> </tr>
> <tr>
> <td>Apple</td>
> </tr>
> <tr>
> <td>Banana</td>
> </tr>
> </table>
>
> How can I accomplish this with xslt?
The default sort will do that, read about xsl:sort
--
Andrew Welch
http://andrewjwelch.com
Kernow: http://kernowforsaxon.sf.net/
|