I have around 100 jquery datatables, all tables contain numeric columns with different order, some of them are int some are float, i want to set the global function which configure the dataTable set numeric format and should be apply on all datatables , the targets columns are different for every table
$.extend($.fn.dataTable.defaults, {
"columnDefs": [{
"targets": [0,1,3],
render: $.fn.dataTable.render.number(',', '.', 0)
}]
});
for int (1234) = 1,234 and for float 1234.00 = 1,234.00
do these changes in code, code is in separate js file.
$.extend($.fn.dataTable.defaults, {
"columnDefs": [{
targets: '_all',
render: function (data, type, full, meta) {
if (Number.isInteger(data)) {
return data.toLocaleString('en-US', { maximumFractionDigits: 0, minimumFractionDigits: 0 });
} else if (isNaN(parseInt(data))) {
return data;
} else {
return data.toLocaleString('en-US', { maximumFractionDigits: 2, minimumFractionDigits: 2 });
}
}
}]
});