[SOLVED] [bash]sort command

schneidz · 04-01-2011, 09:53 PM

hi, i am using this code to create a sorted list by rating like so:

Code:

sort car-rank.tmp -n -r -t \" -k 12 | grep -n . > car-rank.txt
...
548:schneidz:  <worldCar carId="4390297" make="BMW" carName="Z4 M COUPE">    <physicsProfile acceleration="382" handling="414" rating="406" topSpeed="423" tier="2"/>
549:chun-li:  <worldCar carId="4554094" make="AUDI" carName="S5">    <physicsProfile acceleration="405" handling="380" rating="405" topSpeed="430" tier="2"/>
550:akuma:  <worldCar carId="7385671" make="BMW" carName="Z4 M COUPE">    <physicsProfile acceleration="387" handling="414" rating="403" topSpeed="410" tier="2"/>
551:ryu:  <worldCar carId="3638203" make="MAZDA" carName="RX-7">    <physicsProfile acceleration="424" handling="382" rating="402" topSpeed="402" tier="2"/>
552:ken:  <worldCar carId="6906067" make="LEXUS" carName="ISF">    <physicsProfile acceleration="417" handling="426" rating="402" topSpeed="364" tier="2"/>
553:sakura:  <worldCar carId="1487718" make="MAZDA" carName="RX-7">    <physicsProfile acceleration="415" handling="378" rating="401" topSpeed="411" tier="2"/>
...

but i would like the output to look more like:

Code:

...
548:schneidz:  <worldCar carId="4390297" make="BMW" carName="Z4 M COUPE">    <physicsProfile acceleration="382" handling="414" rating="406" topSpeed="423" tier="2"/>
549:chun-li:  <worldCar carId="4554094" make="AUDI" carName="S5">    <physicsProfile acceleration="405" handling="380" rating="405" topSpeed="430" tier="2"/>
550:akuma:  <worldCar carId="7385671" make="BMW" carName="Z4 M COUPE">    <physicsProfile acceleration="387" handling="414" rating="403" topSpeed="410" tier="2"/>
551:ryu:  <worldCar carId="3638203" make="MAZDA" carName="RX-7">    <physicsProfile acceleration="424" handling="382" rating="402" topSpeed="402" tier="2"/>
551:ken:  <worldCar carId="6906067" make="LEXUS" carName="ISF">    <physicsProfile acceleration="417" handling="426" rating="402" topSpeed="364" tier="2"/>
552:sakura:  <worldCar carId="1487718" make="MAZDA" carName="RX-7">    <physicsProfile acceleration="415" handling="378" rating="401" topSpeed="411" tier="2"/>
...

since ryu and ken are tied. does sort have some flag i can pass it that will rank things and be respectful of ties. am i forced to use awk for something like this (does anyone have an example) ?

thanks,
schneidz

grail · 04-02-2011, 03:01 AM

My guess is you would need to sort over multiple items so then a tie will use the second or more columns to influence the sort.
eg. Looking at your example you could use rating and topSpeed and then in the example given ken would be prior to ryu.

schneidz · 04-02-2011, 08:54 AM

^ thx, i gave you a plus 1 but i am still open if anyone got any other ideas.

fyi: i changed all the user names except mine but i think the tie-breaker is alphabetically user name.

schneidz · 04-02-2011, 10:06 AM

hi, i h4x0rz-ed this solution:

Code:

[schneidz@hyper temp]$ cat rank.test | while read line; do  newrank=`echo $line | awk -F\" '{print $12}'`;  if [ $newrank -ne $oldrank ];  then   i=`expr $i + 1`;  fi;  echo $i - $line;  oldrank=$newrank; done
1 - schneidz: <worldCar carId="4390297" make="BMW" carName="Z4 M COUPE"> <physicsProfile acceleration="382" handling="414" rating="406" topSpeed="423" tier="2"/>
2 - chun-li: <worldCar carId="4554094" make="AUDI" carName="S5"> <physicsProfile acceleration="405" handling="380" rating="405" topSpeed="430" tier="2"/>
3 - akuma: <worldCar carId="7385671" make="BMW" carName="Z4 M COUPE"> <physicsProfile acceleration="387" handling="414" rating="403" topSpeed="410" tier="2"/>
4 - ryu: <worldCar carId="3638203" make="MAZDA" carName="RX-7"> <physicsProfile acceleration="424" handling="382" rating="402" topSpeed="402" tier="2"/>
4 - ken: <worldCar carId="6906067" make="LEXUS" carName="ISF"> <physicsProfile acceleration="417" handling="426" rating="402" topSpeed="364" tier="2"/>
5 - sakura: <worldCar carId="1487718" make="MAZDA" carName="RX-7"> <physicsProfile acceleration="415" handling="378" rating="401" topSpeed="411" tier="2"/>

thanks,

grail · 04-03-2011, 04:56 AM

Well here is an alternative to what you have and a single awk:

Code:

while read -r rank line; do (( rank != oldrank )) && (( i++ ));echo $i - $line;oldrank=$rank;done< <(awk -F\" '{print $12,$0}' rank.test)

awk -F\" 'oldrank != $12{i++}{print i,"-",$0;oldrank=$12}' rank.test