Finding records that DO NOT contain a character

[Baylah]

Is it possible to perform a "Find" that will search for records that are missing a charecter from a stricg?

For example....I have a large email list that was given to me I am trying to clean up. If an email address does not have "@" sign it is not a valid email address. Is there a way to search the email field for any address missing the "@" sign?

I am in FM 10 for this project.

Thanks in advance for any help.

Steve

[mr_vodka]

Well you could always do a find and then show ommitted.

You could also use a loop or a calculation field in conjunction with PatternCount () to find those that contain or do not contain the character. Also keep in mind that the @ character is a special character that may need to be escaped out.

[comment]

I believe that searching for:

*@*

and omitting the request should work here.

[Lee Smith]

ah man, I was waiting for Baylah to ask how to escape an operator.

LOL