Shell Programming and Scripting

   $3 ~ /mx$/ && !s12 {
        printf "sales dept 08                                    %s %s\n",time,date
        print "-----------------"
        print "lead1   07q4    07q3    07q2  07q1  06q4    06q3  jan   nov   dec"
        s12++
        }
          s12 {
                if ( $5 ~ /07q1/ ) {
                   f1++
                   }
                if ( f1 ) {
                        s1[$1"_ld "]=$1 ; s1[$1"_7q4 "]=$2 ; s1[$1"_7q3 "]=$3
                        s1[$1"_7q2 "]=$4; s1[$1"_7q1 "]=$5 ; s1[$1"_6q4 "]=$6
                        s1[$1"_6q3 "]=$7 ; s1[$1"_jan "]=$8
                          for ( i in s1 ) { printf "|%s",i s1[i] }
                   }
                if ( ! NF ) {
                        f1=""
                   }
                if ( $5 ~ /dec$/ ) {
                        f3++
                   }
                if ( f3 ) {
                        s3[$1"_nov "]=$4 ; s3[$1"_dec  "]=$5
                           for ( i in s3 ) { printf "|%s",i s3[i] }
                   }
                if ( ! NF ) {
                        f3=""
                   }
                if ( $3 ~ /my/ ) {
                        print "\n"
                        f3=s12=""
                   }
              }

grep -n lead e | cut -d":" -f1 > temp
for i in `cat temp`
do
t=`expr $i + 4`
sed -n "$i,${t}p" e >> 000${i}
done
rm temp
for i in `ls -l 000* | awk '{print $9}'`
do
	sort $i | awk '{
				if(NF<2)
				{
					NF=2
				}
				for(j=1;j<=NF;j++)
				{
					if($j=="")
						$j=0
					printf("%s ",$j)
				}
				printf("\n")
			}'> ${i}.temp
	rm $i
	mv ${i}.temp $i
done
ls -l 000* | awk '{print $9}' | sort -n | paste - - > tt
n=0
while read line
do
	n=`expr $n + 1`
	join $line > t.$n
done < tt
join t.* > final
rm 000*
rm t*
awk '{
if ($1=="tim" || $1=="tad" || $1=="lead1")
print $1" "$3" "$4" "$7" "$8" "$17" "$18" "$19
}' final
rm final