Formatting Thousands Separator in Datatable
Software Used:
- Datatables 1.10.20
- PHPMyAdmin
Table in PHPMyAdmin

Datatable Display Result:

Wanted:
My Client Wanted to formatting JUMLAH column with thousands separator and right aligned like image below:

Question:
How to do that … ?
Answer:
We can make this code below:
$('#your_tbody_id').DataTable({
"columnDefs": [
{ targets: 2, "render": $.fn.dataTable.render.number( '.',',', 0 ) },
{ targets: 2, className: "text-right" }
]
})
Explanation:
- columnDefs is for column definition
- targets: 2 is for targetting column with index 2
- $.fn.dataTable.render.number( ‘.’ , ‘,’ , 0 ) is for formatting number with dot for thousands separator and comma for decimal place and 0 for digit after decimal place
- className: “text-right” is for right aligned
Thanks for reading