Shell Programming and Scripting

file1.txt

type: xx

        xyz               200   300

        xyz1             300   400

Sub total               500   700

type:yy

        abc              200   300

        abc1            100   100

Sub total              500   700

I am expecting


type: xx

        xyz               200   300

        xyz1             300   400

Sub total               500   700

type:yy

        abc              200   300

        abc1            100   100

Sub total              300     400

Total                   800     1100      ---sum of sub totals

awk '/Sub total/{sum1=sum1+$NF; sum2=sum2+$(NF-1)}{print}END{print "Total: " sum2, sum1}' xxx

type: xx

        xyz               200   300

        xyz1             300   400
type:yy

        abc              200   300

        abc1            100   100
type:zz

        ttt              200   300

        ttt1            800   700

type: xx

        xyz               200   300

        xyz1             300   400
Sub Total		500		700
type:yy

        abc              200   300

        abc1            100   100
Sub Total		300		400
type:zz

        ttt              200   300

        ttt1            800   700        
Sub Total		1000		1000
Total		1800		2100

$flag=1;
open FH,"<b.txt";
while(<FH>){
	if(m/type/){
		print "Sub Total		$sub_a		$sub_b\n" if ($.!=1);
		$flag++;
		$sub_a=0;
		$sub_b=0;
		print;
		next;
	}
	else{
			if (m/(.*?  *?)([0-9][0-9]*)(.*?)([0-9][0-9]*)(.*)/)
			{
				$a+=$2;
				$sub_a+=$2;
				$b+=$4;
				$sub_b+=$4;
			}
			print;
	}
}
print "\n";
print "Sub Total		$sub_a		$sub_b\n";
print "Total		$a		$b";

$nawk '/sub total/{sum1=sum1+$NF; sum2=sum2+$(NF-1)}{print}END{print "Total: " sum2, sum1}' test.txt

Invoice Type: CM


INV_TYPE       MONTH        Invoice Count Sum Of Invoices
-------------- ------------ ------------- ---------------
CM             DEC                      1           1,000
               NOV                      1             100

sub total                             2           1,100

Invoice Type: CO


INV_TYPE       MONTH        Invoice Count Sum Of Invoices
-------------- ------------ ------------- ---------------
CO             AUG                      1           5,000

sub total                             1           5,000

Total: 3 6