Shell Programming and Scripting

I have a file like:

<word> 5
<word> 3
<word> 5
<word> 2
<word> 6
<word> 8
<word> 12


and i need to know the max value of the second column, in this case 12.

Plz help me!

Actually i need the TOTAL, AVERANGE and MAX VALUE and i'm using this in awk:

{
sum += $2
}
END {
print "Sum: ", sum, "Average:", sum/NR;
}

But i still need the max value of each column.

nawk -f max.awk myFile

max.awk:

Code:

{
  if ( max[$1] < $2 )
     max[$1]=$2

  tot[$1] +=$2
  avg[$1]++
}
END {
  for (i in max)
    printf("[%s]: total->[%s] avg->[%.2f] max-> [%d]\n", i, tot[i], tot[i]/avg[i], max[i])
}

something is wrong with it cuz it's printing too much values as MAX, maybe the problem is in:
printf("[%s]: max-> [%d]\n", i, arr[i])

Cuz those line is into for

fixed a line-wrap - see the original post.

Something is wrong yet cuz: in file1 i have:

1
2
3
4
2
5
6
23
1

and when i do:
awk -f pmt_max.awk file1

i get:

[2]: total->[4] avg->[2.00] max-> [2]
[23]: total->[23] avg->[23.00] max-> [23]
[3]: total->[3] avg->[3.00] max-> [3]
[4]: total->[4] avg->[4.00] max-> [4]
[5]: total->[5] avg->[5.00] max-> [5]
[6]: total->[6] avg->[6.00] max-> [6]
[1]: total->[2] avg->[1.00] max-> [1]

but i just want an output like:
total= 47 avg= 5,22 max= 23

Plz your help

That was NOT the format of the file you posted originally.
Next time, pls be more specific.

Code:

{
  if ( max < $1 )
     max=$1

  tot+=$1
}
END {
    printf("total->[%s] avg->[%.2f] max-> [%d]\n", tot, tot/FNR, max)
}

This time everything work fine thanx a lot