UNIX for Dummies Questions & Answers

Hello

I have a file like this...

Name |Sex|Security-Number
abx |F |33787728
cdr |M |823483993
derf |F |

i would like to use awk to delete all records from the file that has a blank in the the 3 rd feild .

the output should be like

Name |Sex|Security-Number
abx |F |33787728
cdr |M |823483993

regards
Hrishy

You can probably safely assume that you only want records that end in a digit (i.e. end in a social security number), so you could use grep:

grep -E '[0-9]$' <filename>

If you really wanted to use awk you could use:

awk -F'|' '{if ($3) print }' <filename>