I imported some addresses. But in some records the fields are blank and they are easy to delete but how does on find a space character that is all by itself in the first part of the field with nothing after it.

If I put the cursor in the field I get the blinking insertion point after one space. I need to automate how to find this. I tried IsEmpty function and that doesn't work

Thanks

You could filter the field so that only the characters you wish to be entered exists...

Trim(

Filter ( textField ; "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ 0123456789.,-_()")

)

are you sure there is a character in there? Can you back space the field? You could use the trim feature by itself.

Trim(textField) any record with a true space should be eliminated.

Also check to see if the field is formated to have a custom margin that would make it appear there is a space character in front of where text cursor starts.

thank you

the

Trim(textField) worked when I did an insert calculated result on the field. But is there any way to do a find for that space followed by true empty space in a field

. Then I could delete all found records.

Just wondering

Thanks

Dave

==" "

Should find all records that contain only a single space.

Thank you

That works fine