topic Re: sorting in Operating System - HP-UX

sorting

andi_1 — Thu, 11 Apr 2002 17:27:34 GMT

Hi guys,

For example, I have the following file:

/dev/vg00,/dev/vg00/lvol1,0,25,0,0,0,22,2,100
/dev/vg00,/dev/vg00/lvol2,0,256,0,,0,0,2,1024
/dev/vg00,/dev/vg00/lvol3,0,38,0,0,1,1,2,152
/dev/vg00,/dev/vg00/lvol4,0,25,0,0,0,0,0,100

I'd like to sort the above lines by # of stripes. It is field #8. (where you see 22)

What is the best way to sort the above file, so I have no striped lvol (0) first followed by stripped ones?>

Thank you!

Re: sorting

Bill Hassell — Thu, 11 Apr 2002 17:32:09 GMT

man sort

sort -t, -k8

You can reverse the order with -r. -k is the field number (-k2 sorts by lvol)

Re: sorting

Mark Greene_1 — Thu, 11 Apr 2002 17:34:32 GMT

try this:

sort -t , -k 8 [filename]

HTH
mark

Re: sorting

S.K. Chan — Thu, 11 Apr 2002 17:39:15 GMT

# sort -t, -k8

Re: sorting

andi_1 — Thu, 11 Apr 2002 19:07:04 GMT

Hi guys,

Here is my original file:

1 2 /dev/vg00 /dev/vg00/lvol2 0 256 0 0 0 1 2 1024
1 09 /dev/vgsys /dev/vgsys/lvm 0 125 0 25 0 0 0 1000
1 10 /dev/vgsys /dev/vgsys/lvk 0 125 0 0 0 0 0 1000
1 11 /dev/vgsys /dev/vgsys/lvp 0 125 0 4 0 0 0 1000
1 12 /dev/vgsys /dev/vgsys/lvs 0 125 0 0 0 0 0 1000
1 13 /dev/vgsys /dev/vgsys/lvu 0 50 0 4 0 0 0 400

# sort -t, -r k 8 tmp > tmpSorted

Here is sorted output:
1 13 /dev/vgsys /dev/vgsys/lvu 0 50 0 4 0 0 0 400
1 12 /dev/vgsys /dev/vgsys/lvs 0 125 0 0 0 0 0 1000
1 11 /dev/vgsys /dev/vgsys/lvp 0 125 0 4 0 0 0 1000
1 10 /dev/vgsys /dev/vgsys/lvk 0 125 0 0 0 0 0 1000
1 09 /dev/vgsys /dev/vgsys/lvm 0 125 0 25 0 0 0 1000
1 02 /dev/vg00 /dev/vg00/lvol2 0 256 0 0 0 1 2 1024

Doesn't seem to sort?

Any ideas why?

Thank you!

Re: sorting

A. Clay Stephenson — Thu, 11 Apr 2002 19:11:48 GMT

Hi:

Your original posting had comma's as field separators (hence the -t, argument). You new original file does not have comma's. That is why sort is 'not' working.

Re: sorting

James R. Ferguson — Thu, 11 Apr 2002 19:14:31 GMT

Hi Leon:

Your representation of the data originally showed the field delimiter being a comma (',') and hence the '-t,' option was specified to 'sort'. Therefore, if you input is comma delimited, use '-t,' but if it is space delimited as you show, drop the '-t,' option from the sort specification.

Regards!

...JRF...

Re: sorting

Helen French — Thu, 11 Apr 2002 19:19:53 GMT

Hi Leon,

As Clay suggested, the -t is used to specify the 'character' in the input file.

If you don't have the ',' in the file, then use:

# sort -r -k3 file_name

If you don't use -t it will assume the 'character' as blank.

HTH,
Shiju

Re: sorting

Helen French — Thu, 11 Apr 2002 19:23:50 GMT

oops ..it should be:

# sort -r -k8 tmp > tmpsorted

HTH,
Shiju