for i in PHP-Mar* PHP-Apr* PHP-May* PHP-Jun* do grep Sums $i* 2>/dev/null | tr "\012" "," echo $i done | grep Sums | sed 's/.*Sums,//' > tmp.ec.1 # Use this data to produce data.txt (Note the >> append, not > create.) awk < tmp.ec.1 ' BEGIN {FS=",";} { printf "%3d %3d # %s\n", $1+$2+$3, $5+$6+$7, substr($8,5,5);} '