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?

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

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

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.