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

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

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--