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
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