Search jQuery

jQuery Forum

tablesorter plugin , wrong sort with thousands separators

in Using jQuery Plugins • 6 years ago

I have a problem with the tablesorter plugin, it does not sort properly when used for thousands separators, works only without thousand separators.

Some configuration must be done, have not found anything in the documentation so far.

Thank you for your help.

Jacques.

Replies(2)

Jim OKeefe

Re: tablesorter plugin , wrong sort with thousands separators

4 years ago

Edit the formatFloat function to this:

this.formatFloat = function (s) {

var i = parseFloat(s.replace(/[,]/g, ''));

return (isNaN(i)) ? 0 : i;

};

The problem is that parseFloat treats the first comma as a decimal point. My change strips out the commas before sorting. The original value (with commas) is what appears in the table. I can't point to this as a general solution as Europeans use 1.098.765,34 as separators vs. the 1,098,765.34 that we are accustomed to in the US and other places. The totally correct solution would be to write a custom parser or two...