Text file reading

Question

Hi,


I have one text file having the data in the below format

AA| 12
BB | 15
CC| 10
AA|20
...
...
...
...

in this format first value(AA) is some name and second value (12) is count . so in my requirement i want to read that text file and want to check with the first column in the first line with all other lines in the first column ,if any match is found then the count of the first column shouuld be added to the match column's count.i.e.
AA in first line value is matched with fourth line first column then count of the first column will be 32 (12 +20).

please help me out for the solution,.

Thanks.