Feature Request: custom currency symbols for types

WIR3D

$('#example').dataTable( {
  "columnDefs": [
    { "type": "num-fmt", "symbols":"R$", "targets": 0 }
  ]
} ); 

Should be self explanatory. for now I'm just using a modified plugin (the deprecated currency one) so no rush. just a suggestion.

allan

Good suggestion - thanks for this. This is where DataTables currently defines the currency symbols.

I did wonder about adding in R so it would match (for example) R$123 but it matches in any order, so a simple R would match which wouldn't be right!

Without a more complex algorithm (prefix / postfix check for example) a sorting plug-in is the best way of doing it. Perhaps you might be willing to post your modification so others can also benefit?

Allan

WIR3D

most definitely, let me just finish it. getting some false positives at the moment.

WIR3D

Honestly though, I wouldn't be worried about the order in which it matches the currency, as long as it matches the currency and doesn't have false positives

WIR3D

/**
 * 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
 *  @author modified by Rijnhard Hessel
 */

(function(){

var currencies = 'R';
// Change this list to the valid characters you want
var validChars = '0123456789' + '.,';

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


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

        return null;
    }
);

}());

WIR3D

it needs some more tweaking to be more generic, I haven't figured a way to handle dynaimic type names on the sorter side.

WIR3D

/**
 * This plug-in will provide numeric sorting for currency columns (either 
 * detected automatically with the currency type detection plug-in or set 
 * manually) while taking account of the currency symbol ($ or £ by default).
 *
 * 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 Sort data numerically when it has a leading currency symbol.
 *  @deprecated
 *  @author [Allan Jardine](http://sprymedia.co.uk)
 *  @author modified by Rijnhard Hessel
 *
 *  @example
 *    $('#example').dataTable( {
 *       columnDefs: [
 *         { type: 'currency', targets: 0 }
 *       ]
 *    } );
 */

jQuery.extend( jQuery.fn.dataTableExt.oSort, {
    "randcurrency-pre": function ( a ) {
        a = (a==="-") ? 0 : a.replace( /[^\d\-\.]/g, "" );
        return parseFloat( a );
    },

    "randcurrency-asc": function ( a, b ) {
        return a - b;
    },

    "randcurrency-desc": function ( a, b ) {
        return b - a;
    }
} );

allan

Thanks for sharing with us. That is almost identical to the formatted numbers plug-in :-)

Allan