Shell Programming and Scripting

print "ACNO|NAME|TOWN|VAL1|VAL2|VAL3|VAL4.........V25"

FNR == 1 {
	# Grab the field count from the 1st input line.
	nf = NF
	# Grab account # and name from the 1st input line.
	acno = $1
	name = $2
}

FNR == 1 {
	# Grab the field count from the 1st input line.
	nf = NF
	# Grab account # and name from the 1st input line.
	acno = $1
	name = $2
	# Print the header line.
	printf("ACNO%sNAME%sTOWN%s", OFS, OFS, OFS)
	for(i = 1; i <= nf - 3; i++)
		printf("VAL%d%s", i, (i == nf - 3) ? RS : OFS)
}

#!/bin/ksh
sort -t'|' -k1,1n -k2,2 "${1:-file}" |
awk -F'|' '	
function pt(level,	i) {
	printf("%d%s%s%sTotal%s", acno, OFS, name, OFS, OFS)
	for(i = 4; i <= nf; i++) {
		printf(OFMT "%s", s[i], (i == nf) ? RS : OFS)
		t[i] += s[i]
		s[i] = 0
	}
	if(level) {
		printf("%d%s-%sACNO Total%s", acno, OFS, OFS, OFS)
		for(i = 4; i <= nf; i++) {
			printf(OFMT "%s", t[i], (i == nf) ? RS : OFS)
			t[i] = 0
		}
	}
}
	OFMT = "%.2f"
	OFS = FS
}
FNR == 1 {
	nf = NF
	acno = $1
	name = $2
}
{	
	if(acno != $1) {
		pt(1)
		acno = $1
		name = $2
	}
	if(name != $2) {
		pt(0)
		name = $2
	}
	for(i = 4; i <= nf; i++)
		s[i] += $i
}
1	
END {	
	pt(1)
}'