DataTables example Language - Comma decimal place

A dot (.) is used to mark the decimal place in Javascript, however, many parts of the world use a comma (,) and other characters such as the Unicode decimal separator () or a dash (-) are often used to show the decimal place in a displayed number.

When reading such numbers, Javascript won't automatically recognise them as numbers, however, DataTables' type detection and sorting methods can be instructed through the language.decimalDT option which character is used as the decimal place in your numbers. This will be used to correctly adjust DataTables' type detection and sorting algorithms to sort numbers in your table.

Any character can be passed in using the language.decimalDT option, although the decimal place character used in a single table must be consistent (i.e. numbers with a dot decimal place and comma decimal place cannot both appear in the same table). Different tables on the same page can use different decimal characters if required.

The example below shows a comma being used as the decimal place in the currency numbers shown in the final column.

NamePositionOfficeAgeStart dateSalary
NamePositionOfficeAgeStart dateSalary
Airi Satou Accountant Tokyo 33 2008/11/28 $162.700,00
Angelica Ramos Chief Executive Officer (CEO) London 47 2009/10/09 $1.200.000,00
Ashton Cox Junior Technical Author San Francisco 66 2009/01/12 $86.000,00
Bradley Greer Software Engineer London 41 2012/10/13 $132.000,00
Brenden Wagner Software Engineer San Francisco 28 2011/06/07 $206.850,00
Brielle Williamson Integration Specialist New York 61 2012/12/02 $372.000,00
Bruno Nash Software Engineer London 38 2011/05/03 $163.500,00
Caesar Vance Pre-Sales Support New York 21 2011/12/12 $106.450,00
Cara Stevens Sales Assistant New York 46 2011/12/06 $145.600,00
Cedric Kelly Senior Javascript Developer Edinburgh 22 2012/03/29 $433.060,00
Showing 1 to 10 of 57 entries

The Javascript shown below is used to initialise the table shown in this example:

1
2
3
4
5
6
7
8
$(document).ready(function() {
    $('#example').dataTable( {
        "language": {
            "decimal": ",",
            "thousands": "."
        }
    } );
} );

In addition to the above code, the following Javascript library files are loaded for use in this example: