UNIX for Beginners Questions & Answers

Have a text file containing 4 columns, the 4th column is sorted numerically in descending order. The 2nd column is alpha text. Been able to get the 4th column to sort in descending order. The 2nd column sorts correctly but it's also in reverse. Would like to be able to keep the 4th column sort numerically descending while the 2nd column is sorted a-z, not z-a. This is what I have and can't seem to get it to work because everything is reversed.

Code:

sort -k2 -k4 -r file

this is what I'm trying to get:

Code:

xxxx apples xxxx 100
xxxx apples xxxx 90
xxxx oranges xxxx 80
xxxx oranges xxxx 70
xxxx pears xxxx 100
xxxx pears xxxx 90

this is what I'm getting because everything is reversed:

Code:

xxxx pears xxxx 100
xxxx pears xxxx 90
xxxx oranges xxxx 80
xxxx oranges xxxx 70
xxxx apples xxxx 100
xxxx apples xxxx 90

I'm sure this is simple but just can't get it to work.

Code:

sort -k2 -k4nr file

Yoda, this iteration is causing the 4th column to no longer sort descending numerically. Think I tried this one.

I get:

Code:

$ sort -k2 -k4nr myFile
xxxx apples xxxx 100
xxxx apples xxxx 90
xxxx oranges xxxx 70
xxxx oranges xxxx 80
xxxx pears xxxx 100
xxxx pears xxxx 90

is that what you're NOT after?

I'm on Solaris,

Code:

sort -k2 -k4nr file

is giving this:

Code:

xxxx apples xxxx 90 
xxxx apples xxxx 100 
xxxx oranges xxxx 80 
xxxx oranges xxxx 70
xxxx pears xxxx 90 
xxxx pears xxxx 100

don't have Solaris atm, but try this:

Code:

sort -k2 -k4n,4r myFile

Yes! It works, it is the other real life data I am not showing in my example. Thanks guys.