NOTE!

Demo

Account #
Difference
3: Ratings (max)
4: Ratings (min)
5: Change (max)
6: Change (min)
7: Change (top)
8: Change (bottom)
9: Change (zero)
A43 -35 01 01 -.1 -.1 -.1 -.1 -.1
A255 33 02 02 N/A #1 N/A #1 N/A #1 N/A #1 N/A #1
A33 2 03 03 N/A #2 N/A #2 N/A #2 N/A #2 N/A #2
A1 -5 04 04 -8.4 -8.4 -8.4 -8.4 -8.4
A102 99 05 05 -2.2 -2.2 -2.2 -2.2 -2.2
A10 -1 06 06 97.4 97.4 97.4 97.4 97.4
A02 0 07 07 23.6 23.6 23.6 23.6 23.6
A55 44 11.4 11.4 11.4 11.4 11.4
A87 04 NR NR 5.2 5.2 5.2 5.2 5.2
A012 NR NR

Javascript

$(function() {
// call the tablesorter plugin
$("table").tablesorter({
theme : 'blue',
// default strings setting
stringTo: "max",
// columns 2 & 3 (zero-based index) set using headers option
// columns 4+ set using header class name: "string-max", "string-min", "string-top", "string-bottom" and "string-none"
headers: {
1: { sorter: "digit", empty : "top" }, // sort empty cells to the top
2: { sorter: "digit", string: "max" }, // non-numeric content is treated as a MAX value
3: { sorter: "digit", string: "min" } // non-numeric content is treated as a MIN value
}

});
});

HTML

<table>
<thead>
<tr>
<th>Account #</th>
<th>Difference</th>
<th>3: Ratings (max)</th>
<th>4: Ratings (min)</th>
<th class="string-max">5: Change (max)</th>
<th class="string-min">6: Change (min)</th>
<th class="string-top">7: Change (top)</th>
<th class="string-bottom">8: Change (bottom)</th>
<th class="string-none">9: Change (zero)</th>
</tr>
</thead>
<tbody>
<tr>
<td>A43</td>
<td>-35</td>
<td>01</td>
<td>01</td>
<td>-.1</td>
<td>-.1</td>
<td>-.1</td>
<td>-.1</td>
<td>-.1</td>
</tr>
<tr>
<td>A255</td>
<td>33</td>
<td>02</td>
<td>02</td>
<td>N/A #1</td>
<td>N/A #1</td>
<td>N/A #1</td>
<td>N/A #1</td>
<td>N/A #1</td>
</tr>
<tr>
<td>A33</td>
<td>2</td>
<td>03</td>
<td>03</td>
<td>N/A #2</td>
<td>N/A #2</td>
<td>N/A #2</td>
<td>N/A #2</td>
<td>N/A #2</td>
</tr>
<tr>
<td>A1</td>
<td>-5</td>
<td>04</td>
<td>04</td>
<td>-8.4</td>
<td>-8.4</td>
<td>-8.4</td>
<td>-8.4</td>
<td>-8.4</td>
</tr>
<tr>
<td>A102</td>
<td>99</td>
<td>05</td>
<td>05</td>
<td>-2.2</td>
<td>-2.2</td>
<td>-2.2</td>
<td>-2.2</td>
<td>-2.2</td>
</tr>
<tr>
<td>A10</td>
<td>-1</td>
<td>06</td>
<td>06</td>
<td>97.4</td>
<td>97.4</td>
<td>97.4</td>
<td>97.4</td>
<td>97.4</td>
</tr>
<tr>
<td>A02</td>
<td>0</td>
<td>07</td>
<td>07</td>
<td>23.6</td>
<td>23.6</td>
<td>23.6</td>
<td>23.6</td>
<td>23.6</td>
</tr>
<tr>
<td>A55</td>
<td>44</td>
<td></td>
<td></td>
<td>11.4</td>
<td>11.4</td>
<td>11.4</td>
<td>11.4</td>
<td>11.4</td>
</tr>
<tr>
<td>A87</td>
<td>04</td>
<td>NR</td>
<td>NR</td>
<td>5.2</td>
<td>5.2</td>
<td>5.2</td>
<td>5.2</td>
<td>5.2</td>
</tr>
<tr>
<td>A012</td>
<td></td>
<td>NR</td>
<td>NR</td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</tbody>
</table>

Next up: Disable or set the column parser using class names ››