Hello all...
I have a slight problem in my awk script...
I have a script which checks a csv file and keeps a count of any invalid records and then if it finds any, exits with a code of 1. problem is it dosnt seem to work properly :rolleyes: Everthing seem to work interms of the stats output, but if clause in the END block dosnt seem to work? any ideas would be greatly appreciated!
Kind Regards
Satnam
awk -F, -v invalid_rec_count=0 ' { if (NF!=field_count) {
invalid_rec_count+=1 ;
if (invalid_rec_count<=max_spool) {
print $1;
}
}
}
#END { printf "%-10s\t\n","Total Lines["NR"]" ; if (invalid_rec_count=5) { "App error" ; exit 1 ;} }
END { printf "%-10s\t\n%-10s\t\n","Total Lines["NR"]","Invalid["invalid_rec_count"]" ; if (invalid_rec_count=5) { exit 1 } }
' max\_spool="$bad\_file\_max_spool" field\_count="$FIELD_COUNT" $data\_dir\_and_file