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

Subject: [xsl] sorting a table based on first column which contains both numbers and words
From: "Robby Pelssers" <robby.pelssers@xxxxxxxxx>
Date: Thu, 17 Dec 2009 16:01:51 +0100
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?

Kind regards,
Robby Pelssers

Current Thread