I'm trying to sort a file by max values in column 8 (Raw), here is a sample of the data:
I tried to tackle this dataset with the following sort script:
sort -t$'\t' -k8,8 -nr glm_ref.detail2 > glm_ref_detail_sort
however, the output file keeps sorting on the first column? I removed the header info to simplify the process but for some reason it wants to sort on the ID column (column 1) which has many missing values. Any ideas?
Ideally the file will be sorted by Raw, starting with the max positive number and ending with the largest negative number.