Hi,
I need an awk script (or whatever shell-construct) that would take data like below and get the max value of 3 column, when grouping by the 1st column.
clientname,day-of-month,max-users
-----------------------------------
client1,20120610,5
client2,20120610,2
client3,20120610,7
client4,20120610,9
client5,20120610,2
client1,20120611,8
client3,20120611,4
client4,20120611,4
client6,20120611,9
and get results like:
clientname,max-monthly-users
-----------------------------
client1,8
client2,2
client3,7
client4,9
client5,2
client6,9
The column-header lines are not required, but I thought would make example more concrete.
Thanks-In-Advance For any help!