The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Column sum group by uniq records
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Column sum group by uniq records
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #5 (permalink)  
Old 02-16-2009
sandeep13 sandeep13 is offline
Registered User
  
 

Join Date: Feb 2009
Posts: 8
Column sum group by uniq records
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