I've been working a little with Christian Bach's nifty Tablesorter plugin for jQuery, and I'd like to share some cool stuff I've learned.
I wanted to sort a column of time spans formatted like this: "2 days 15:11:06". I wrote a custom parser and ended up with this:$.tablesorter.addParser({
id: 'timespan',
is: function(s) { return false; }, // don't auto detect
format: function(s) { return s.replace(/\D/g,""); },
type: 'numeric'
});
And the usage:$("#mytable").tablesorter({
headers : {
2 : 'timespan' // the 3rd column is a time span
}
});
All it's doing is removing all non-digits and asking for a numeric comparison. It should even work equally well for "0 days 02:30:00" and for "02:30:00", since leading zeros don't affect the sorting :-)
Showing posts with label timespan. Show all posts
Showing posts with label timespan. Show all posts
Wednesday, April 23, 2008
Sorting time spans with jQuery Tablesorter
Labels:
jquery,
programming,
sorting,
tablesorter,
timespan
Subscribe to:
Posts (Atom)


