Formatted numbers

formatted_numbers

  • Author: Allan Jardine
  • Deprecated: This plug-in has been deprecated and replaced with other functionality. Please see the detailed description below for more information.

This plug-in will strip out non-numeric formatting characters such that a formatted number (for example 1,000,000) can be detected automatically and sorted numerically. Note that characters a-z are not automatically removed, otherwise there is a risk of detecting columns as numeric which should not be.

DataTables 1.10+ has formatted number type detection and sorting abilities built-in. As such this plug-in is marked as deprecated, but might be useful when working with old versions of DataTables.

Plug-in code

jQuery.fn.dataTableExt.aTypes.unshift(
    function ( sData )
    {
        var deformatted = sData.replace(/[^\d\-\.\/a-zA-Z]/g,'');
        var isNumeric = !isNaN( deformatted - parseFloat( deformatted ) );

        return isNumeric || deformatted === "-" ?
            'formatted-num' :
            null;
    }
);

CDN

This plug-in is available on the DataTables CDN:

JS

Note that if you are using multiple plug-ins, it is beneficial in terms of performance to combine the plug-ins into a single file and host it on your own server, rather than making multiple requests to the DataTables CDN.

Version control

If you have any ideas for how this plug-in can be improved, or spot anything that is in error, it is available on GitHub and pull requests are very welcome!