Numerical sort with non-numeric values (But mathematically accepted)

Numerical sort with non-numeric values (But mathematically accepted)

smorettismoretti Posts: 9Questions: 0Answers: 0
edited November 2012 in General
Hi

I have numeric values to sort. Sometimes some of these values are +inf, -inf or null/na (not assigned).
Is there a way to do that with DataTables.

It seems the regular sort with numeric type can sort numerical and empty values as it should, but cannot deal with +/-inf or na.

Thanks

Replies

  • smorettismoretti Posts: 9Questions: 0Answers: 0
    I have implemented this myself.
    Prior to a normal numeric sort, I replaced +inf and -inf by respectively very high and very low values (values I will never see in my data), and replaced NA by an impossible numeric value.
This discussion has been closed.