I need help in developing a script.
A flat file count.dat is created everyday through some processes
and it contains values like this--
NAME DEPT CITY COUNT
SCOTT MRKT NEW YORK 100
SCOTT MRKT NEW JERS 150
TIGER ACCT ATLANTA 200
PETER IS ATLANTA 100
MIKE HR NEW YORK 50
SAM HR PORT 300
SAM IS PORT 200
SCOTT MRKT PORT 100
I need a Shell script that reads this file and create a new file name CALCL.DAT after
performing following calculations
SUM(COUNT) group by NAME,DEPT,CITY,COUNT.
Your help is higly appreciated.