JQuery tablesorter: change the way you sort empty cells

Question

I have a large table and you want to sort using tablesorter. The problem I'm dealing with is that tablesorter acts like 0 for empty cells when sorting with numbers. How can I pull empty cells down?

As an example, tablesorter sorts as

-5 -4 -1 <empty cell> <empty cell> 6 7 15 23 

I want to sort as

 -5 -4 -1 6 7 15 23 <empty cell> <empty cell> 

Answer 1

You can specify your own text extraction function:

  $(table).tablesorter({ textExtraction: function (node) { if (node.innerHTML.length == 0) { return "999999999"; // or some suitably large number! } else { return node.innerHTML; } } } );