Solved

Datatables jQuery Format Problem

Posted on 2013-11-13
9
1,135 Views
Last Modified: 2016-03-02
I am using the datatables plug in and i want to show numerical data with 2 decimal places.

I am using similar php scripts that the author uses and as such, i don't to format the data at that stage.. i want to format the data client side

I have found a datatables article : http://datatables.net/forums/discussion/comment/23760 but it uses depreciated methods

I also want to produce my own calculated columns

Thanks
0
Comment
Question by:maddisoncr
  • 6
  • 2
9 Comments
 

Author Comment

by:maddisoncr
Comment Utility
0
 
LVL 44

Expert Comment

by:Rainer Jeschor
Comment Utility
Hi,
depending on your data / html source, the following option should work:
            "aoColumnDefs": [ 
            {
                "mRender": function ( data, type, row ) {

                    return parseFloat(data).toFixed(2);
                },
                "aTargets": [ 6 ]
            }

Open in new window

Just verify the column index - from the attached PDF it looks like column 7 (hence index 6).

Sample:
http://jsfiddle.net/EE_RainerJ/3frAT/

HTH
Rainer
0
 

Author Comment

by:maddisoncr
Comment Utility
Thank you so much, i really appreciate it

How would i go about looking at calculated columns ?
0
 

Author Comment

by:maddisoncr
Comment Utility
thanks again for that, it's working great

in terms of adding commas.. i presume i would still use the plug in as before ?
0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 500 total points
Comment Utility
Hi,
calculated columns should probably work the same.

I have updated the above sample:
http://jsfiddle.net/EE_RainerJ/3frAT/

Using this as mRender function:
            "aoColumnDefs": [ 
            {
                "mRender": function ( data, type, row ) {
                    var tempNumber = parseFloat(data.trim()).toFixed(2);
                    if (isNaN(tempNumber)) {
                        return "";
                    } else {
                    var sArray = (""+tempNumber).split('.');
                    return sArray[0].split(/(?=(?:.{3})+$)/).join(",") + "." + sArray[1];
                }
                },
                "aTargets": [ 3 ]
            }
        ]

Open in new window


HTH
Rainer
0
 

Author Comment

by:maddisoncr
Comment Utility
Thanks so much, i'll test that this afternoon :-)
0
 

Author Comment

by:maddisoncr
Comment Utility
Thanks again.. Brilliant
0
 

Author Closing Comment

by:maddisoncr
Comment Utility
Great help
0
 

Expert Comment

by:plpitcher
Comment Utility
{
                               "mRender": function (data, type, row) {
                                   return parseFloat('currentBalance').toFixed(2);
                               }
                           },
The above is not working for me.  What do I need to do?  The data type for 'currentBalance' is decimal.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

I have answered several questions lately that were solved utilizing the power of jQuery's AJAX functions, so I thought I would write an article demonstrating the ease of use. Why should I use jQuery as opposed to regular JavaScript? Now I know…
Introduction A frequently asked question goes something like this:  "I am running a long process in the background and I want to alert my client when the process finishes.  How can I send a message to the browser?"  Unfortunately, the short answer …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now