hi,

i have a file with 20 columns where 4th column is an acct number and 14th column in a field which has only 2 distinct values as 002 and null.

now i want those aact numbers where the 14th column is null. how do i extract using awk command.

zcat filename | awk -F "|" '$14 ~ /002/ {print $4}'

this command gives all accounts with 002 value. but how do i take the remaining. it does not work if I give blank spaces.

please help.