Validate record format

[gxh1000]

I need to validate that each record contains exactly 5 comma separated fields in my file.

ex. a,b,c,d,e

If any record doesn't match the format, then fail. Thanks for your help.

 

[vgersh99]

nawk -f val.awk data.txt
if [ $? -ne 0 ] ; then
echo "failed"
fi

#--------------- val.awk
BEGIN {
FS=","
st="0"
}

NF != 5 { st=1; exit }

END {
exit st;
}

vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[PHV]

Try something like this:

awk -F, 'NF!=5' /path/to/yourfile >/tmp/check$$
[ -s /tmp/check$$ ] && {
  echo "PROBLEM with fields:"; cat /tmp/check$$
  exit 1
}

Hope This Help
PH.

 

[Salem]

This should get you started...

BEGIN {
  FS=","
}
NF != 5 {
  # fail code goes here
}