Datatables Sorting For Alphanumeric Column

Question

I am using Datatables for Sorting the ID column.

ID

MPT123

RST789

AZE190

How can I sort this based on Numeric Values I tried by doing

"columnDefs": [{
            targets: "datatable-nosort",
            orderable: false,
            bsort: false,
            sType: "numeric"
}]

But this didn't worked.

So you want to sort on the number, ignoring the letters before it? Are all IDs of the form AAA000? — Chris H.
– Chris H., Commented Sep 2, 2016 at 15:04

Cork Kochi · Accepted Answer · 2016-09-02 15:27:39Z

1

I got it working , posting the working code

jQuery.extend( jQuery.fn.dataTableExt.oSort, {
"formatted-num-pre": function ( a ) {       
    a = (a === "-" || a === "") ? 0 : a.replace( /[^\d\-\.]/g, "" );
    return parseFloat( a );
},

"formatted-num-asc": function ( a, b ) {
    return a - b;
},

"formatted-num-desc": function ( a, b ) {
    return b - a;
}
} );

And call the method as

{ "type": "formatted-num", targets: 0 }]

edited Sep 2, 2016 at 15:27

answered Sep 2, 2016 at 15:09

Cork Kochi

1,9218 gold badges32 silver badges53 bronze badges

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

1 Comment

Sebastianb Over a year ago

Just FYI, there might be a simpler way using the render function and returning a parseInt of the number part of the string when type = 'sort'. Kudos on finding a solution on your own, though!

Jitesh Sojitra · Accepted Answer · 2017-10-05 09:24:33Z

0

I'm using natural sorting JS and works great - https://datatables.net/plug-ins/sorting/natural#Example

Sort data with a mix of numbers and letters naturally. Data can often be a complicated mix of numbers and letters (file names are a common example) and sorting them in a natural manner is quite a difficult problem.

Fortunately a deal of work has already been done in this area by other authors - the following plug-in uses the naturalSort() function by Jim Palmer to provide natural sorting in DataTables.

answered Oct 5, 2017 at 9:24

Jitesh Sojitra

4,0937 gold badges32 silver badges51 bronze badges

Collectives™ on Stack Overflow

Datatables Sorting For Alphanumeric Column

ID

MPT123

RST789

AZE190

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

ID

MPT123

RST789

AZE190

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related