awk delete blank records

awk delete blank records

 

  

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



____________________________________________________________
Nokia Game is on again.
Go to http://uk.yahoo.com/nokiagame/ and join the new
all media adventure before November 3rd.
Oracle LazyDBA home page