[SOLVED] Script to add up numbers in textfile

philipz · 05-20-2010, 08:06 AM

All,

I have a textfile that - after parsing a lot - looks like the following:

Mark 3245
Mark 67436
Mark 821
Owen 35
Owen 870
Patrick 6321
Patrick 34
Ruben 47

Result should be:
Mark 71502
Owen 905
Patrick 6355
Ruben 47

I guess this would be doable with an AWK loop where you add up $2 for all lines where $1 is the same...

Any ideas how that would work (or even without awk ofcourse)?

Thanks a lot in advance!

theNbomr · 05-20-2010, 08:18 AM

This is a classic case for the use of associative arrays (language-agnostic example):

Code:

    person{$1} = person{$1} + $2;

Until the first encounter with each 'person' (the key field), the array element does not exist. Thereafter, it exists, has a numeric value, and can be arithmetically manipulated. This kind of code can be used in Awk, Perl, PHP (I think), Python (I think), maybe some others.
--- rod.

grail · 05-20-2010, 08:26 AM

Code:

awk '{_[$1]+=$2}END{for(x in _)print x,_[x]}' file

philipz · 05-20-2010, 08:38 AM

Quote:

Originally Posted by grail

Code:

awk '{_[$1]+=$2}END{for(x in _)print x,_[x]}' file

Not sure how it does the job but that works...
Thanks guys for the help, much appreciated!