Subject: 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
|