script wanted

[peterchu]

I have a very large file , the content as below,


11 11 "d1"
22 22 "a2"
33 33 "12"
44 44 "37"

I want to sort it by column 3 from small to large ( now the order should be 12 --> 37 --> a2 --> d1 ) so the result should be as below. besides , there are a "" sign on column 3 ,

33 33 "12"
44 44 "37"
22 22 "a2"
11 11 "d1"

What can I do ? thx

[john korterman · Accepted solution]

Hi,

what is wrong with:
sort -k3

regards,
John K.

[Simon Hargrave]

The fact that there are quotes around the 3rd column is of no concequence, given it's there on every row, so will not differ as far as sort is concerned.

So you can simply sort on the 3rd field with: -

sort -k3 verylargefile

[Bharat Katkar]

Hi,
# cat abc
33 33 "12"
44 44 "37"
22 22 "a2"
11 11 "d1"
#
# sort -k3 abc
33 33 "12"
44 44 "37"
22 22 "a2"
11 11 "d1"
#

Works perfectly. And this is what you want.
Regards,

[peterchu]

thx all