Currency

Detect data of numeric type with a leading currency symbol.

  • Author: Allan Jardine, Nuno Gomes
  • 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 add automatic detection for currency columns to DataTables. Note that only $, £ and € symbols are detected with this code, but it is trivial to add more or change the current ones. This is best used in conjunction with the currency sorting plug-in.

DataTables 1.10+ has currency sorting abilities built-in and will be automatically detected. As such this plug-in is marked as deprecated, but might be useful when working with old versions of DataTables.

Plug-in code

(function(){

// Change this list to the valid characters you want
var validChars = "$£€c" + "0123456789" + ".-,'";

// Init the regex just once for speed - it is "closure locked"
var
    str = jQuery.fn.dataTableExt.oApi._fnEscapeRegex( validChars ),
    re = new RegExp('[^'+str+']');


jQuery.fn.dataTableExt.aTypes.unshift(
   function ( data )
    {
        if ( typeof data !== 'string' || re.test(data) ) {
            return null;
        }

        return 'currency';
    }
);

}());

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!