Sort numbers with string in one row

arelam

I have a table where one of the columns is numbers only and sorting is ok. But in my case sometimes one of the entries appears as pending (string) and sorting becomes as string. Is there a way to force it ignore the string and put it in the bottom of the column?

Technodawg

Did you ever resolve your issue? I have a similar problem.

ztevie

I wonder the same...
I have all numbers in one column, but occasionally the value will be "EXTRA". I set the type to "num", and the sorting is ok with all the numbers, but the EXTRA rows will always be last, no matter if I sort the column asc or desc... I'd like them to be last when in ascending order, but come first when descending...

kthorngren

Have yu tried the natural sorting plug-in:
https://datatables.net/plug-ins/sorting/natural

Kevin

ztevie

Thanks a million, Kevin!!
Natural did excactly what I wanted. I need to check external plugins more I think...