Sorting alphanumeric column in datatables doesent work

Question

I have some problem to sort a column in jquery data table.

I want to sort the first column ascending/descending.

This is some data from the column (default sorted by desc):

AS you can see the default Sorting algorithm doesn't work with alphanumeric characters.

This are my settings:

$('#myTable').dataTable({
            "aaSorting": [[0, "desc"]],
            "paging": false,
            "lengthChange": false,
            "searching": true,
            "ordering": true,
            "info": true,
            "autoWidth": false
)}

my wish descending result:

Anybody have some hint what I do wrong? I also tried to use

"columnDefs": [
{"type": "natural", "targets": 0 }]

But this also doesn't work

Simion · Accepted Answer · 2018-08-13 10:50:02Z

0

The string your are yousing is calculated:

R0xxxxx < R1xxxxx < R2xxxxxx < R3xxxxx < R4xxxxx < R5xxxxx etc ...

You need to do natural sort:

function naturalSort(a, b) {
        var ax = [], bx = [];

        a.replace(/(\d+)|(\D+)/g, function(_, $1, $2) { ax.push([$1 || Infinity, $2 || ""]) });
        b.replace(/(\d+)|(\D+)/g, function(_, $1, $2) { bx.push([$1 || Infinity, $2 || ""]) });
        
        while(ax.length && bx.length) {
            var an = ax.shift();
            var bn = bx.shift();
            var nn = (an[0] - bn[0]) || an[1].localeCompare(bn[1]);
            if(nn) return nn;
        }

        return ax.length - bx.length;
    }

    test = [
    "R12",
    "R10",
    "R2",
    "R1",
    "R101",
    "R101",
    "R10"
];

    test.sort(naturalSort);
    document.write("<pre>" + JSON.stringify(test,0,3));

edited Aug 13, 2018 at 10:50

answered Aug 13, 2018 at 10:21

Simion

3331 silver badge9 bronze badges

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

2 Comments

frTsf3f Over a year ago

Is there a way to tell datatables to ignore the 'R' or to split the String value inside the datatables settings?

Simion Over a year ago

It is another question, which you can find answers in the stackoverflow. one of them could be: stackoverflow.com/questions/18554921/…

Collectives™ on Stack Overflow

Sorting alphanumeric column in datatables doesent work

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related