identifying null values in a file

dsravan · February 12, 2008, 2:42pm

I have a huge file with 20 fileds in each record and each field is seperated by "|". If i want to get all the reocrds that have 18th or for that matter any filed as null how can i do it? Please let me know

bobbygsk · February 12, 2008, 2:56pm

To identify the null values on any field

dsravan · February 12, 2008, 3:01pm

But i want to see if particular field is null or not and not regular nulls in the file

jim_mcnamara · February 12, 2008, 4:28pm

# lets do it for field #18
fld=18
awk -v fld=$fld ' -F'|'  \
   ' { if ($fld=="") { print "Line " $NR " has field " $fld " NULL" }}' myfile