Hello all

I have a text file with 2 columns. This file is sorted by its 2nd column. Some of the entries in this column are duplicated (I don't care about duplicates in the other column). I want to remove the duplicated entries, according to the 2nd column, but if an entry is duplicated, the values in the 1st column must be added. For example, if I have the following file

Column 1 Column 2
1 a
2 b
4 b
8 b
16 c
10 c

I want a script that returns to me the following table:

Column 1 Column 2
1 a
14 b
26 c


Is there a way, using awk, sed, or any other terminal command, to do it? I don't want to open the file in Excel or a similar software because:

1) I have 1.207.522 rows
2) I need to use this procedure in, at least, 36 different files. Maybe there are more to come

A typical example to unleash the power of awk:

Awesome! It works perfectly!

Thanks

lol ... of course it does !!!.
@colucix strikes again ....

i would tend to think excel to be the best solution here however,

you could use grep in a loop of some sort coupled with sed and basic bash mathematics to achieve your goal, if you have a limited range for the second column then you could use a simple for loop, post back with your range and i'll see if i can help further

Good

Be cautious that the output may be out of order as 'in' does not preserve order.