javascript - How to sort a number with thousands separator -

-

i have tried sort number jquery datatables plug-in not working c# string number formats.

i have tried:

decimal value= 12345678.00 value..tostring("#,##.00"); value.tostring("##,##.##"); value.tostring("0,0.00", cultureinfo.invariantculture)

but no luck because of comma. if there no comma works fine or numbers same count working i.e.

01,121,372.01

02,002,009.22

11,222,222,33

if below not working

1,111,111.11

222,191.00

32,222.00

for datatables 1.10

datatables 1.10+ has formatted number detection , sorting abilities built- in, there no coding needed.

alternatively can set columns.type num-fmt force specific data type.

see example below demonstration.

$(document).ready(function() {    $('#example').datatable();    });                            
<!doctype html>  <html>    <head>  <meta charset="iso-8859-1">    <link href="//cdn.datatables.net/1.10.7/css/jquery.datatables.min.css" rel="stylesheet" />  <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" />  <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>  <script src="//cdn.datatables.net/1.10.7/js/jquery.datatables.min.js"></script>      </head>  <body>  <table id="example" class="display" cellspacing="0" width="100%">      <thead>      <tr>        <th>name</th>        <th>position</th>        <th>office</th>        <th>age</th>        <th>start date</th>        <th>salary</th>      </tr>    </thead>      <tfoot>      <tr>        <th>name</th>        <th>position</th>        <th>office</th>        <th>age</th>        <th>start date</th>        <th>salary</th>      </tr>    </tfoot>      <tbody>      <tr>        <td>tiger nixon</td>        <td>system architect</td>        <td>edinburgh</td>        <td>61</td>        <td>2011/04/25</td>        <td>111,111.11</td>      </tr>      <tr>        <td>garrett winters</td>        <td>accountant</td>        <td>tokyo</td>        <td>63</td>        <td>2011/07/25</td>        <td>222,191.00</td>      </tr>      <tr>        <td>ashton cox</td>        <td>junior technical author</td>        <td>san francisco</td>        <td>66</td>        <td>2009/01/12</td>        <td>32,222.00</td>      </tr>    </tbody>  </table>  </body>  </html>

for datatables 1.9

for older datatables 1.9 can use formatted numbers sorting plug-in.

you need include js file: //cdn.datatables.net/plug-ins/1.10.7/sorting/formatted-numbers.js , use code below set data type formatted number.

$('#example').datatable({    columndefs: [      { type: 'formatted-num', targets: 0 }    ] });

Comments

Post a Comment

Popular posts from this blog

java - HTTP Status 500 - An exception occurred processing JSP page /second.jsp at line 15 -

-
this question has answer here: what nullpointerexception, , how fix it? 12 answers i have 4 pages on jsp web project student showing details db.. have used tomcat web server. index.html <body> <h1> student search page</h1> <form action="second.jsp"> <h2> enter id search details</h2> <input type=text name=id1 /> <br/> <input type=submit value=search /> </form> </body> second.jsp <body> <% string id =(request.getparameter("id1")); studentdao std=new studentdao(); student s=std.searchinfo("id"); %> <h1> <%=s.showstudent()%></h1> </body> student.java import java.io.*; public class student implements serializable { string name; string id1,phone,clas; ...
Read more

SQL Server - MyCTE query based on 24 hour period (next day) -

-
i have bit of code: ;with mycte ( select *, row_number() over(partition carduser order cardtableid) newvariation cardchecker ) update mycte set status = newvariation which updates status column, want happen on 24 hour period, status starts again next day @ 1, , counts again based on carduser specified above: current data , happens: 2 aaa 1 2015-06-25 08:00:00.000 123 1 null 3 ccc 1 2015-06-25 00:00:00.000 124 1 null 4 aaa 1 2015-06-25 17:30:00.000 125 2 null 5 aaa 1 2015-06-26 17:30:00.000 125 *3* null what want happen: 2 aaa 1 2015-06-25 08:00:00.000 123 1 null 3 ccc 1 2015-06-25 00:00:00.000 124 1 null 4 aaa 1 2015-06-25 17:30:00.000 125 2 null 5 aaa 1 2015-06-26 17:30:00.000 125 *1* null im not quite sure how add above query possible point me in right direction? the main problem eventtime field contains both date , time, adding partition means status 1 based on time parameter of field thanks ...
Read more

php - Using str_replace to translate a MySQL Table in html -

-
i have website contains pricelist of cs:go items. now, how did this: mysql db w/ prices --> select db x ( item name ) --> echo table ( works fine ) now want translation of item names. how planned it: mysql db --> $result= ( signature character ) --> $translate = str_replace (signature character $result) however, there's issue code or str_replace think. $translate returns $result no filtering. <?php require 'lang.php'; $servername = "localhost"; $username = ""; $dbname = ""; $password = ""; // create connection $conn = new mysqli($servername, $username, $password, $dbname); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } // filter name $sql = "select name, price utf name 'k%'"; $result = $conn->query($sql); // translate $tr = str_replace('k','karambit','$result'); // ech...
Read more