CODEWITHSUNDEEP
jquerytablesorter
rasputin
rasputin

Reputation: 380

JQuery tablesorter: Modify how it sorts empty cells

I have a big table and want to sort using tablesorter. The problem I'm dealing with is that tablesorter act as 0 for empty cells when sorting with numbers. How can I push the empty cells to bottom?

As an example, tablesorter sorts like that

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

Upvotes: 7

Views: 2462

Answers (1)

Fiona - myaccessible.website
Fiona - myaccessible.website

Reputation: 14921

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;
            }           
        }       
} );

Upvotes: 10

Related Questions