Jquery datatables format numbers

Question

I use the latest Datatables plugin 1.10 version.

I have 3 columns (0 , 1, 2). Columns 1 and 2 contain numbers which should be formatted like:

1000 -> 1.000
10000 -> 10.000

I searched the documentation and I found these relevant functions:

https://datatables.net/reference/option/formatNumber

https://datatables.net/reference/option/language.thousands

Are the columns that need to be formatted detected automatically?

What is the correct usage of the above functions?

you should use regex inside mRender on your targets[2] and format the number respectively with regex and bind it to table depending on your requirement . ex: "render": function(data) {//return formatted value;} }, — super cool
– super cool, Commented Dec 11, 2014 at 10:46
@supercool this works. u can write an answer to mark as accepted — gosom
– gosom, Commented Dec 12, 2014 at 12:45

JustLearning · Accepted Answer · 2016-08-26 11:37:33Z

42

There is actually an even easier way to do this, also found on the datatables documentation:

        "columns": [
            { "data": "ReceiptQuantity", render: $.fn.dataTable.render.number(',', '.', 2, '') },
            { "data": "ReceiptPrice", render: $.fn.dataTable.render.number(',', '.', 2, '') },
            { "data": "LineTotal", render: $.fn.dataTable.render.number(',', '.', 2, '') }
        ],

answered Aug 26, 2016 at 11:37

JustLearning

3,3423 gold badges37 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

ba_ul Over a year ago

Here's the documentation: datatables.net/manual/data/renderers#Built-in-helpers. I was having some difficulty locating this, so thought the link might help others.

fabpico Over a year ago

Filter initialization crashes and i recieve Uncaught TypeError: Cannot read property 'mData' of undefined.

dokam_scotland Over a year ago

Perfect. It's fine for me this solution :)

user2342558 Over a year ago

It works, also the ordering by column works after number formatting.

user2342558 · Accepted Answer · 2021-04-27 13:24:00Z

5

$('#table-dg').dataTable({
    "columns": columnNames,
    "columnDefs": [
        {
            "render": function (data, type, row) {
                 return commaSeparateNumber(data);
            },
            "targets": [1,2]
        },
    ]
});

function commaSeparateNumber(val) {
    while (/(\d+)(\d{3})/.test(val.toString())) {
        val = val.toString().replace(/(\d+)(\d{3})/, '$1' + ',' + '$2');
    }

    return val;
}

edited Apr 27, 2021 at 13:24

user2342558

6,8046 gold badges42 silver badges67 bronze badges

answered Jul 30, 2015 at 15:15

RAS

1091 silver badge6 bronze badges

2 Comments

Daniel Hoffmann-Mitscherling Over a year ago

Welcome to stackoverflow! When answering questions, it's best to add a description to the answer code you have provided.

user2342558 Over a year ago

It works for formatting numbers but it brokes the ordering by column: all values will be ordered in a wrong order. @JustLearning's answer works for me.

super cool · Accepted Answer · 2014-12-12 15:14:27Z

4

As mentioned in my comment you have to do something like this

Inside Datatable initialization :

 "aoColumnDefs": [ {
      "aTargets": [ 2 ],
    "mRender": function (data, type, full) {
     var formmatedvalue=data.replace(//regex expression)
      return formmatedvalue;
    }
}]

answered Dec 12, 2014 at 15:14

super cool

6,0653 gold badges34 silver badges67 bronze badges

Collectives™ on Stack Overflow

Jquery datatables format numbers

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related