# Formatted Number Sorting With Some Text Data

# Formatted Number Sorting With Some Text Data

I have a simple table with formatted numbers that are being sorted nicely with the formatted numbers plug in. The initial values are grams with 2 decimal points, like this: 15.60g.

However, in some columns there are fields where the text is "n/a", as the numerical data is not available. The formatted numbers sorting plug in has trouble with these columns and will not sort them. You can see an example of this problem in the "sug" column here: http://www.whichprotein.co.uk/protein/whey/nutrition/

Ideally these "n/a" should be sorted to the top (largest values) when the column is sorted. Is there any way I can easily modify the formatted numbers plug in to allow for this, or should I be combining multiple plug ins somehow? Here's the plug in code:

[code]

jQuery.fn.dataTableExt.oSort['formatted-num-asc'] = function(x,y){

x = x.replace(/[^\d\-\.\/]/g,'');

y = y.replace(/[^\d\-\.\/]/g,'');

if(x.indexOf('/')>=0)x = eval(x);

if(y.indexOf('/')>=0)y = eval(y);

return x/1 - y/1;

}

jQuery.fn.dataTableExt.oSort['formatted-num-desc'] = function(x,y){

x = x.replace(/[^\d\-\.\/]/g,'');

y = y.replace(/[^\d\-\.\/]/g,'');

if(x.indexOf('/')>=0)x = eval(x);

if(y.indexOf('/')>=0)y = eval(y);

return y/1 - x/1;

}

[/code]

Thanks in advance!

This discussion has been closed.

## Replies

Allan

[code]

jQuery.fn.dataTableExt.oSort['formatted-num-asc'] = function(x,y){

if ( x == "n/a" ) x= 0;

if ( y == "n/a" ) y= 0;

x = x.replace(/[^\d\-\.\/]/g,'');

y = y.replace(/[^\d\-\.\/]/g,'');

if(x.indexOf('/')>=0)x = eval(x);

if(y.indexOf('/')>=0)y = eval(y);

return x/1 - y/1;

}

jQuery.fn.dataTableExt.oSort['formatted-num-desc'] = function(x,y){

if ( x == "n/a" ) x= 0;

if ( y == "n/a" ) y= 0;

x = x.replace(/[^\d\-\.\/]/g,'');

y = y.replace(/[^\d\-\.\/]/g,'');

if(x.indexOf('/')>=0)x = eval(x);

if(y.indexOf('/')>=0)y = eval(y);

return y/1 - x/1;

}

[/code]

I've tried multiple variations of that too. I definitely need to learn more javascript.

Any ideas where I'm going wrong?

Allan