I have a tab-separated ASCII file.
One of the columns contains numbers which always have a decimal point (like 0.311225363556077).
However, in this column entries might also be any one of these strings:
Inf -Inf NA
I would like to sort the lines of this file, by the value in that column. How can I do that?
I was thinking about using (GNU) sort, but I can't figure out if it recognizes Inf and -Inf properly.
The sort order should be: from top to bottom: Inf, numbers in order, -Inf, NA
This is on Debian.