Find out if few fields in a file are null

rudoraj · October 21, 2009, 3:21pm

Hi,
I've a pipe delimited file where I want to find out a number of lines where 1st 2nd and last field are null using awk/sed. Is it possible?

Thanks

cfajohnson · October 21, 2009, 3:32pm

awk -F\| ' !$1 || !$2 || !$NF { print NR, "empty field" }'

rudoraj · October 21, 2009, 3:36pm

Great this gives number of recrods. Would it be possible to print the lines instead?

Thanks

cfajohnson · October 21, 2009, 3:41pm

You can put whatever you want it to do inside the braces.

rdcwayx · October 22, 2009, 7:50am

Wrong one, ignore it. awk -F\| '{$1=$2=$NF=""}'1 urfile

awk -F\| ' !$1 || !$2 || !$NF { print $0 }'

cfajohnson · October 22, 2009, 3:53pm

That assigns an empty string to those fields; it doesn't tell whether they are empty.