Dear All,

I want to get help for below case.
I have a file like this.


saman 1
gihan 2
saman 4
ravi 1
ravi 2

so i want to get the result,

saman 5
gihan 2
ravi 3 like this.

Pls help me.

Thank you.

What have you tried so far?

This can be done using associative array in awk.

$ cat nayan.out
saman 1
gihan 2
saman 4
ravi 1
ravi 2

$ awk '{arr[$1]+=$2} END {for (i in arr) {print i,arr[i]}}' nayan.out > nayan.out.tmp

$ cat nayan.out.tmp
ravi 3
saman 5
gihan 2

Dear Jadu,

Thank u ! it is working.

Thanks you again,

Nayanajith.

Hi Jadu,

I am new to unix and i have a similar requirement given below:

Input file:

Test.txt
PORT; ID; TOTAL
port1;p1;100000
port2;p2;5000
port1;p1;500

Output file:
PORT; ID; TOTAL
port1;p1; 100500
port2;p2; 5000

How can achive this? Any help on this regard is higly appreciated.
Thanks.

Regards,
Sandeep

Try below script ( Not tested)

awk -F ";" '{ arr[$1 ";" $2] += $3 } END {for (i in arr) {print i ";" arr[i] } }' inputfile

Hi Ranjith,
Thanks for the reply but this doesn't work....can we use like arr[$1 ";" $2]???

Regards,
Sandeep