search for a string , and add if it matches

Posted by Sharat Chandra on Stack Overflow See other posts from Stack Overflow or by Sharat Chandra
Published on 2010-05-04T17:00:49Z Indexed on 2010/05/04 17:08 UTC
Read the original article Hit count: 244

Filed under:
|
|

I have a file that has 2 columns as given below....

101   6
102   23
103   45
109   36
101   42
108   21
102   24
109   67

and so on......

I want to write a script that adds the values from 2nd column if their corresponding first column matches

for example add all 2nd column values if it's 1st column is 101
add all 2nd column values if it's 1st colummn is 102
add all 2nd column values if it's 1st colummn is 103 and so on ...

i wrote my script like this , but i'm not getting the correct result

awk '{print $1}' data.txt > col1.txt
while read line
do
    awk ' if [$1 == $line] sum+=$2; END {print "Sum for time stamp", $line"=", sum}; sum=0' data.txt
    done < col1.txt

© Stack Overflow or respective owner

Related posts about awk

Related posts about bash