UNIX and Linux Forums - Search Results

Showing results 1 to 2 of 2 Search took 0.00 seconds. Search: Posts Made By: RudiC

Forum: Shell Programming and Scripting 03-18-2015

Group by in UNIX

1,319

Posted By

You were halfway there. Try awk -F, '{if (a[$2]<...

You were halfway there. Try awk -F, '{if (a[$2]< $3) {a[$2]=$3;b[$2]=$1}} END{for(i in a){print b[i],i,a[i];}}' OFS="," file
zzz,1,3000
ttttt,2,500
xyxy,3,1000

or awk -F, 'a[$2] < $3...

Forum: Shell Programming and Scripting 03-18-2015

Group by in UNIX

1,319

Posted By

Show us your attempts. What stops you from...

Show us your attempts. What stops you from printing the lines with respective groups' max?

Showing results 1 to 2 of 2