topic Re: sort command question in Operating System - HP-UX

sort command question

kenny chia — Thu, 19 Aug 2004 03:18:23 GMT

I need to sort a csv file by the 3rd column then by the 2nd column

I used the following command

sort -t, -k 3,2 data.csv

but it ends up sorting by column 2 then by column 3 only

how should I sort by column 3 then column 2??

Re: sort command question

Steve Steel — Thu, 19 Aug 2004 03:36:43 GMT

Hi

Try

sort -t, -k 3,3 -k 2,2 data.csv

steve Steel

Re: sort command question

Franky_1 — Thu, 19 Aug 2004 03:44:14 GMT

Hi,

cat | sort -k 3 -k 2 >

should do the trick

Regards

Franky

Re: sort command question

Muthukumar_5 — Thu, 19 Aug 2004 03:50:46 GMT

We can not use key values as,

-k 3,2

start point of key = 3
end point ok key = 2

Man page -->
The characters at positions
field_start and field_end are included in the key
field, providing that field_end does not precede
field_start.

IF you want to sort based on column 3 first then column 2 next then,

use two keys as,

-k 3 -k 2 ( -k 3,3 -k 2,2 )

it will process sorting with 3rd field then 2nd field.

Examples:
Master1 # cat /tmp/for.log
hai,23,4
bye,56,1
you,67,2
me,34,6

Master1 # sort -t , -k 3 -k 2 /tmp/for.log
bye,56,1
you,67,2
hai,23,4
me,34,6

Master1 # sort -t , -k 3,2 /tmp/for.log
bye,56,1
hai,23,4
me,34,6
you,67,2

Regards
Muthu

Re: sort command question

kenny chia — Thu, 19 Aug 2004 04:09:27 GMT

Hi Muthu

sort -t, -k 3,3 -k 2,2

works