From ThaiiS Note (Wiki)
wikimedia
Examples
Text after a number (e.g. a footnote) does not affect the sorting order, if the sorting mode is numeric. However, if the number at the top has text after it, this makes the sorting mode alphabetic.
| numbers
|
| 4.0
|
| 123,456.789
|
| 123,456,789
|
| 2,500,000,000
|
| 300,000,000
|
| 3,000,000 abc
|
| 5,000,000
|
| 2,000 def
|
| -4,000
|
| aaa
|
| -9,999
|
| 4,000
|
| 9,999
|
| 800,000
|
| 900,000
|
|
| numbers
|
| 123 564,589.7e12
|
| 9
|
| -80
|
| 80 abc 5
|
| abc 80
|
| 70
|
| 600
|
|
| first alphabetic, later also numeric mode
|
| 123.4 ghi
|
| 2,500,000,000
|
| 300,000,000
|
| 3,000,000 abc
|
| 5,000,000
|
| 2,000 def
|
| 4,000
|
| 9,999
|
| 800,000
|
| 900,000
|
|
2
| currencies
|
| $ 9
|
| $ 80
|
| $ 70
|
| $ 600
|
|
| currencies
|
| € 9
|
| € 80
|
| € 70
|
| € 600
|
|
| currencies
|
| £ 9
|
| £ 80
|
| £ 70
|
| £ 600
|
|
| currencies
|
| ¥ 9
|
| ¥ 80
|
| ¥ 70
|
| ¥ 600
|
|
| comparison
|
| a 9
|
| a 80
|
| a 70
|
| a 600
|
|
| comparison
|
| e 9
|
| e 80
|
| e 70
|
| e 600
|
|
3
The example with "a" gives alphabetic sorting; that with "e" ditto, the data are not mistaken for numbers in scientific format.
| mixed notations
|
| {{#expr:1000000000000000000/7}}
|
| 1000000000000000000
|
| -1000000000000000000
|
| .0000000000000000001
|
| -.0000000000000000001
|
| {{#expr:-1000000000000000000/7}}
|
| {{#expr:.000000000001/7}}
|
| {{#expr:-.000000000001/7}}
|
| 89 123 456 788
|
| 89,123,456,789
|
| 333
|
| 1e10
|
| e 9
|
| e 80
|
| e 70
|
| e 600
|
| 999e9
|
| 88e80
|
| 7e270
|
| 999e-9
|
| 88e-80
|
| 7e-270
|
| -999e9
|
| −999e9
|
| -88e80
|
| -7e270
|
| -999e-9
|
| -88e-80
|
| -7e-270
|
| e3
|
| -e3
|
| 1e3
|
| e9
|
| e80
|
| e270
|
| 6e11
|
| 8e11
|
|
| first number in each element counts
|
| 7-4
|
| 2
|
| 4
|
| 22/7
|
| 111
|
|
|
| mixed notations
|
| 14
|
| -14
|
| 11
|
| -12 (retrograde)
|
| 12 or 13
|
| 12 (?)
|
| ca. 12
|
| 12 (approx.)
|
| ?
|
|
jquery tablesort
<script src="http://thaiis.com/thaiis-scripts/tablesort/jquery-1.6.2.min.js" type="text/javascript"></script>
<script type="text/javascript" src="http://thaiis.com/thaiis-scripts/tablesort/jquery.tablesorter.min.js"></script>
<script type="text/javascript" src="http://thaiis.com/thaiis-scripts/tablesort/jquery.tablesorter.pager.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#myTable").tablesorter();
}
);
</script>
<link href="http://thaiis.com/thaiis-scripts/tablesort/blue/style.css" rel="stylesheet" type="text/css" />
<table id="myTable" class="tablesorter">
<thead>
<tr>
<th>Last Name</th>
<th>First Name</th>
<th>Email</th>
<th>Due</th>
<th>Web Site</th>
</tr>
</thead>
<tbody>
<tr>
<td>Smith</td>
<td>John</td>
<td>jsmith@gmail.com</td>
<td>$50.00</td>
<td>http://www.jsmith.com</td>
</tr>
<tr>
<td>Bach</td>
<td>Frank</td>
<td>fbach@yahoo.com</td>
<td>$50.00</td>
<td>http://www.frank.com</td>
</tr>
<tr>
<td>Doe</td>
<td>Jason</td>
<td>jdoe@hotmail.com</td>
<td>$100.00</td>
<td>http://www.jdoe.com</td>
</tr>
<tr>
<td>Conway</td>
<td>Tim</td>
<td>tconway@earthlink.net</td>
<td>$50.00</td>
<td>http://www.timconway.com</td>
</tr>
</tbody>
</table>
