#Records that have more than 8 fields
BEGIN { FS="," ;
MaxFields=11 #Number of fields in Records
errCnt=0 #Records with Errors
errRec="These Records have Errors:"
printf("\n");
printf("\n \n");
#printf("\n");
#printf("\n \n");
printf("\n
Check Fields of Data file
\n");
}
{
#first record is header
if (NR == 1) {
printf("
Info: Number of Fields Required=%s\n Number of Records Found=%s\n
", NF, NR)
printf("
\n");
tableValBegin="
"
tableValEnd="
"
for (f=1; f <= MaxFields ;f++)
{
if (f == 1 ) {
printf("\n\n
%s%s%s", tableValBegin, $1, tableValEnd);
}
else {
printf("%s%s%s\n\n", tableValBegin,$(f), tableValEnd) ;
}
}
#Goto next record after printing title for table/template of fields
next
}
else {
printf("\n
\n");
tableValBegin="
"
tableValEnd="
"
}
#look thru fields
for (f=1; f <= NF; f++)
{
if (f == 1 ) {
if (NF != MaxFields) {
errRec = errRec " " NR ": NF=" NF "=" $0
errCnt = errCnt + 1
printf("\n\n
", tableValBegin, $f, tableValEnd);
} else {
printf("%s%s%s\n\n", tableValBegin,$f, tableValEnd) ;
}
}
#Stop after x number of Records
#Only process this many records
if (NR == 800)
exit
}
END {
print "