topic Re: sort via multiple keyfields in Operating System - HP-UX

sort via multiple keyfields

Boyd Kodama — Mon, 22 Apr 2002 13:01:03 GMT

Trying to sort the following listing (ls):

file1.10
file1.11
file1.8
file1.9
file2.1
file2.10
file2.2
file2.3
file3.1
file3.10
file3.2

so the result is:

file1.8
file1.9
file1.10
file1.11
file2.1
file2.2
file2.3
file2.10
file3.1
file3.2
file3.10

Already tried `ls | sort -n -t.` which sorts the first
field only and `ls | sort -n -t. +1` which sorts the second field only.

Also tried `ls | sort -n -t. -k 1,2` which sorts the
second field only.

Any ideas?

thanks,

Boy

Re: sort via multiple keyfields

John Strang — Mon, 22 Apr 2002 13:18:12 GMT

Hi Boyd,

Try redirecting the output of the first sort into the second, as follows:

`ls | sort -n -t. | sort -n -t. +1`

This uses both the sorts you have already tried, but combining them together.

I'll try it later today and let you know how it goes....

John

Re: sort via multiple keyfields

A. Clay Stephenson — Mon, 22 Apr 2002 13:22:52 GMT

This should do it:

cat myfile | sort -t '.' -k 1,1b -k 2,2n > newfile

Re: sort via multiple keyfields

Boyd Kodama — Mon, 22 Apr 2002 13:33:41 GMT

Thanks Clay. Yours worked.

Sorry John, the second `sort`
re-sorts the whole list according to the second field.

Boyd

Re: sort via multiple keyfields

John Strang — Mon, 22 Apr 2002 14:08:59 GMT

Hi Boyd,

Apologies for posting an incorrect solution - I'd not considered the fact that the second sort would re-sort the whole list :-(

John