/**
* 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.
*
* @name Currency
* @summary Detect data of numeric type with a leading currency symbol.
* @deprecated
* @author [Allan Jardine](http://sprymedia.co.uk), Nuno Gomes
*/
(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';
}
);
}());
|
Download
