Delete Blanks Script Troubles

[mrpez1]

I'm importing records into a phone number database that will be connected to my rolodex database via a portal. I'm importing each phone number, extension and type (Fax, Main Company, Direct, ext..) into a record with the contact's ID number. This works fine except for when a contact doesn't have a Fax (for example) and a blank record is imported, gumming up the portal with blanks. I wrote a script to go through each record, see if the phone number field is empty, and if it is, delete the record. Here it is:

Go to Record/Request/Page [First]

Loop

If ["IsEmpty(Phone#)"]

Delete Record/Request [No Dialog]

Else

Go to Record/Request/Page [Exit After Last, Next]

End If

End Loop

Exit Script

This generally works but it is leaving the odd blank behind...maybe 100 out of 6000 records...Any ideas why and how I can fix this?

[Fitch]

The script looks right. Maybe there is in fact something in the field that's not obvious.

[Ugo DI LUCA]

What about a Show All records at first step.May be these 100 empty records are in the omitted records...?

[mrpez1]

Looks like Fitch hit it on the head. Apparently the 100 had spaces in them. I added a line to delete any records where phone#=" " and that seems to have done it. Thanks, guys.