Re: [xsl] sorting a table based on first column which contains both numbers and words

Subject: Re: [xsl] 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/

Current Thread