UNIX for Dummies Questions & Answers

I have a file that looks like this

2 4 10 500 tim9
5 8 14 700 tim9
3 5 15 432 john1
1 4 12 999 ellen2

So basically what i want to do is fine duplicate names on column 5 and rename it with an extention (i.e. tim9_1 and tim9_2).

so the output file will look like this

2 4 10 500 tim9_1
5 8 14 700 tim9_2
3 5 15 432 john1
1 4 12 999 ellen2

is this possible with awk?

Also I want to know the statistics on a column (like how many lines there are and also the sum of the values in that column)

eg.
1 3 6 7 3
2 4 7 3 2
1 4 7 4 2

So I want to know a awk command that will sum column 5 and tell me how many lines. In the example above, it will be sum = 7 and the total # of lines is 3.

Thanks for the help. The file that I have is huge so this would help a lot

Kyle

Code:

nawk '$5 in a {$5=$5 "_" ++a[$5]}{a[$5];print}' myTimFile

Code:

nawk '{sum+=$5;fnr=FNR} END{printf("sum=%d total # of lines=%d\n", sum, fnr)}' mySumLinesFile