xsl-list
[Top] [All Lists]

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

2009-12-17 10:28:26
2009/12/17 Robby Pelssers <robby(_dot_)pelssers(_at_)ciber(_dot_)com>:
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/

--~------------------------------------------------------------------
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>
--~--