Shell Programming and Scripting

Hello Guru s


I need your kind help to solve my below issue

I have a directory of flat files and have to calculate sum of some columns from the flat file .

Say for flat file 302 I need the column summation of 2 and 3 rd column
For flat file 303 I need the column summation of 5 and 6th column

Do you guys have any thought which logic will be the best to solve it
Can I store the flat file name and column in separate flat file and will calculate the sum via reading that file

The flat file separator is | (pipe)
Its kinda urgent .

Thanks for investing your thought and time

Code:

$ nawk -F\| '{sum+=$2} {add+=$3} END {print sum,add}' file_302

You could continue the original thread.

Create a file with the entries like..

filename,col1,col2

Code:

$ cat stat 
f1,2,3
f2,5,6
$ 
$
$ while IFS="," read fname cname1 cname2
> do
> awk -F\| -v c1=$cname1 -v c2=$cname2 '{sum1+=$c1;sum2+=$c2} END {print sum1 FS sum2}' $fname
> done < stat
8|12
20|24
$