Sorting on column which contains numbers and "Unlimited" text

greenman123

I have a datatable which has sortable column containing stock numbers, a few rows contain the word "Unlimited" and this stops the sorting working correctly.

I have read a number of posts on this forum and the suggestions are sType (which looks like it might be from an old version) and natural sorting (?)

How can I make this column sort the numbers with "Unlimited" cells the highest sortable number?

greenman123

For reference: http://live.datatables.net/bezahepi/1/

kthorngren

Using columns.type won't help since you have two different data types in one column. You can use Orthogonal Data for this. Use columns.render similar to the documentation example. You will need to set both the sort value and the type value so that the column type is set to numeric. Here is the update example:
http://live.datatables.net/bezahepi/2/edit

Kevin

greenman123

Yep brilliant - thanks