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

sort command

Srinivas_9 — Tue, 18 Apr 2006 10:40:37 GMT

Sort experts please help
I am trying to come up with a sort command that will sort the following input ...first on the 1st field in ascending order then the on 2nd field in numerically descending order based on the digits that follows the string "City"

========Input===========
Akron C9.23.A1.City11
Baltimore C8.90.C1.City4
Chattanooga C51.9.A1.City5
Akron C9.99.A1.City8
Akron C9.21.A1.City9
Baltimore C8.99.C1.City99
Baltimore C8.99.C1.City1
Chattanooga C51.9.A1.City6

========Expected Output===========
Akron C9.23.A1.City11
Akron C9.21.A1.City9
Akron C9.99.A1.City8
Baltimore C8.99.C1.City99
Baltimore C8.90.C1.City4
Baltimore C8.99.C1.City1
Chattanooga C51.9.A1.City6
Chattanooga C51.9.A1.City5

Note: first the cities are sorted and then within the cities it is numerically sorted in descending order based on the digits that follow the string "City"

Tried the following command and few more combinations nothing seems to be the solution for my requirements.

sort -k1 -k2.14nr inputfile

Salome to anyone who has spend their valuable time on this

Re: sort command

Tiziano Contorno _ — Tue, 18 Apr 2006 11:14:59 GMT

Hi Srinivas, this is the most long and less efficient script I could elaborate :)

for CITY in $(sort -uk1,1 tmp_input | awk '{print $1}')
do
for NUM in $(awk -F'City' -vCITY=$CITY '$1 ~ CITY {print CITY, $2}' tmp_input | sort -n | awk '{print $2}')
do
echo "$(awk -F'City' -vNUM=$NUM -vCITY=$CITY '$1 ~ CITY && $2 ~ NUM' tmp_input)"
done
done

And this gives this:

Akron C9.23.A1.City11
Akron C9.99.A1.City8
Akron C9.21.A1.City9
Baltimore C8.99.C1.City1
Baltimore C8.90.C1.City4
Baltimore C8.99.C1.City99
Chattanooga C51.9.A1.City5
Chattanooga C51.9.A1.City6

So no perfect ordering since you have mixed one-two char numbers.

It could be a starting point.

Regards.

Re: sort command

Peter Nikitka — Tue, 18 Apr 2006 11:22:28 GMT

Hi,

first: it is always advisable to restrict the search, if multiple fields are involved.
However, this does not give your desired result as well:
sort -k1,1 -k2.14nr inputfile

I have seen several times, that the sort-command had problems when dealing with numerical mode AND dots '.' in the string to be sorted.
Try this hack (you can use another 'interim char' as Â§ as long it is not part of your data). It works with Solaris8 (just no HP at hand).

sed -e 's/ /Â§/' -e 's/City/&Â§/' inputfile | sort -tÂ§ -k1,1 -k3,3nr | sed -e 's/Â§/ /' -e 's/Â§//'

mfG Peter

Re: sort command

Rodney Hills — Tue, 18 Apr 2006 11:26:59 GMT

What if adjust the input file for sorting, then put it back-

sed 's/City/City /' inputfile | sort -k1 -k3nr | sed 's/City /City/'

HTH

-- Rod Hills

Re: sort command

Kent Ostby — Tue, 18 Apr 2006 11:39:05 GMT

sort -k1b,1 -k2.14nr,2.16 inputfile

Re: sort command

A. Clay Stephenson — Tue, 18 Apr 2006 11:39:14 GMT

My cut at this would be to use awk to extract the digits following city then sort it and finally reassemble it with awk.

awk '{ split($2,x,"City"); print $1, x[2], $2 }' | sort -k 1,1 -k 2nr,2nr | awk '{print $1, $NF}' < infile > outfile

Re: sort command

Srinivas_9 — Tue, 18 Apr 2006 15:00:54 GMT

Guys thanks a lot for the overwhelming response. As this is a minor requirement in a very complicated script, I will let u know which of the solutions offered below suits best for me.

You guys are awesome.

Re: sort command

Sandman! — Tue, 18 Apr 2006 18:44:10 GMT

Hi Srinivas,

In your command sequence the "-k1" will try to sort from the first field to the end of the line...so your next "-k2.14nr" sort key will be ignored. You need to tell sort to restrict the first key "-k1,1" before moving onto the second sort key "-k2.14nr".

# sort -k1,1 -k2.14nr inputfile

cheers!

Re: sort command

Arturo Galbiati — Wed, 19 Apr 2006 03:17:20 GMT

Hi Srinivas,
sort -k1b,1 -k2.14nr,2.16 inputfile
run on my HPUX1i:

10:12 GPOP09BN hpbbnn1/tmp/> cat f1
Akron C9.23.A1.City11
Baltimore C8.90.C1.City4
Chattanooga C51.9.A1.City5
Akron C9.99.A1.City8
Akron C9.21.A1.City9
Baltimore C8.99.C1.City99
Baltimore C8.99.C1.City1
Chattanooga C51.9.A1.City6

10:16 GPOP09BN hpbbnn1/tmp/> sort -k1b,1 -k2.14nr,2.16 f1
Akron C9.23.A1.City11
Akron C9.21.A1.City9
Akron C9.99.A1.City8
Baltimore C8.99.C1.City99
Baltimore C8.90.C1.City4
Baltimore C8.99.C1.City1
Chattanooga C51.9.A1.City6
Chattanooga C51.9.A1.City5

HTH,
Art

Re: sort command

Srinivas_9 — Wed, 19 Apr 2006 20:53:51 GMT

Guys thanks for the solutions provided.
Some worked some didnt.

But I picked Rodney Hills solution for its simplicity and suited my needs exactly.

LongLive HPForum.

Re: sort command

Srinivas_9 — Wed, 19 Apr 2006 20:56:31 GMT

Closing thread.