Sorting columns is calculating numbers in my text?

ChrisG

I have columns with the following data:

4/5
1

5/5
2

5/5
11

How can I get it to sort ascending like this:

5/5
11

5/5
2

4/5
1

So basically it just sorts the first line alphabetically and the second line numerically. Thanks in advance. :)

allan

Its sorting the column with "4/5" (for example) as a string since it contains non-numerical data (the `/` ). If you want it to sort numerically, you need to create a sorting plug-in that will calculate the decimal value from the fraction: http://datatables.net/development/sorting#type_based

Allan

ChrisG

I actually want to treat the fraction part as text only.

So sort by the "4/5" text and then sort by the number below that. Is that possible?

allan

Sure - you just need to make a plug-in which will extract the fraction from the string, calculate the value as a decimal and use that sort the sorting in your sorting function.

Allan