NOTE!
- Click on any column header to sort that column.
- The alphanumeric sort working in the first column was added in version 2.0.6 (not part of the original plugin).
- The above sort was replaced with a natural sort in version 2.2.
- This example demonstrates that common table values are auto-detected (including plain text, currency, percentages, and positive & negative numbers), so there is no need to set a specific parser unless you notice an issue with how a column is sorting.
- Issues may arise if a column contains mixed data, e.g. "N/A" is located at the top of a numeric column; in this case the column will be detected as a text column and not a numeric column. If issues occur, add a
sorter-digit
class name to that header cell.
Demo
Account # |
First Name |
Last Name |
Age |
Total |
Discount |
Diff |
---|---|---|---|---|---|---|
A1 | Bruce | Almighty | 45 | 153.19 | 44% | +19 |
A10 | Frank | Carter | 40 | -12.99 | 20% | (6) |
A23 | Elvis | Presley | 24 | ($9.99) | 50% | (22) |
A33 | Clark | Kent | 18 | 2.89 | 44.2% | -15 |
A43 | Peter | Parker | 28 | 9.99 | 20.3% | +3 |
A102 | Bruce | Evans | 56 | $153.19 | 23% | +9 |
A255 | John | Hood | 33 | 19.99 | 25.1% | -7 |
A256 | John | Clark | 44 | ($19.89) | 25.1% | (5) |
Javascript
$(function() {
// call the tablesorter plugin
$("table").tablesorter({ theme : 'blue' });
});
HTML
<!-- the data-sortlist won't apply because it is supported by jQuery v1.4+; and this demo is using jQuery v1.2.6 -->
<table class="tablesorter" data-sortlist="[[0,0]]">
<thead>
<tr>
<th>Account #</th>
<th>First Name</th>
<th>Last Name</th>
<th>Age</th>
<th>Total</th>
<th>Discount</th>
<th>Diff</th>
</tr>
</thead>
<tbody>
<tr>
<td>A43</td>
<td>Peter</td>
<td>Parker</td>
<td>28</td>
<td>9.99</td>
<td>20.3%</td>
<td>+3</td>
</tr>
<tr>
<td>A255</td>
<td>John</td>
<td>Hood</td>
<td>33</td>
<td>19.99</td>
<td>25.1%</td>
<td>-7</td>
</tr>
<tr>
<td>A33</td>
<td>Clark</td>
<td>Kent</td>
<td>18</td>
<td>2.89</td>
<td>44.2%</td>
<td>-15</td>
</tr>
<tr>
<td>A1</td>
<td>Bruce</td>
<td>Almighty</td>
<td>45</td>
<td>153.19</td>
<td>44%</td>
<td>+19</td>
</tr>
<tr>
<td>A102</td>
<td>Bruce</td>
<td>Evans</td>
<td>56</td>
<td>$153.19</td>
<td>23%</td>
<td>+9</td>
</tr>
<tr>
<td>A256</td>
<td>John</td>
<td>Clark</td>
<td>44</td>
<td>($19.89)</td>
<td>25.1%</td>
<td>(5)</td>
</tr>
<tr>
<td>A23</td>
<td>Elvis</td>
<td>Presley</td>
<td>24</td>
<td>($9.99)</td>
<td>50%</td>
<td>(22)</td>
</tr>
<tr>
<td>A10</td>
<td>Frank</td>
<td>Carter</td>
<td>40</td>
<td>-12.99</td>
<td>20%</td>
<td>(6)</td>
</tr>
</tbody>
</table>