Wildcard search: working with @

[Meetloaf]

I have a simple problem (I hope). I wish to validate e-mail addresses. I just want to do a simple search that tells me all the addresses that do not have the form: "[email protected]"

I was hoping to accomplish this by doing a search, something like *@*.* ...however, the @ is a wildcard from what I understand. Any ideas how I can do this?

[Raybaudi]

Hi

as you have the Advanced version of FMP 8, you can use a custom function like this.

[Raybaudi]

... like this

[comment]

The "@" character is a "character with special meaning" when defining search criteria, so it needs to be escaped. See Help > Finding, sorting, and replacing data > Finding records > Finding text and characters.

[Meetloaf]

The custom function works great. Thanks!

Edited January 3, 2007 by Guest

[Pedropon]

... like this

Thanks for the tips,

but I just don't know how to validate an email entry field with an extensive error message using IsEmailValid. The only thing I succeed to do for now is to create a button next to the field that call a script using IsEmailValid to correctly display errors.

Thanks

[Raybaudi]

Hi

you don't need a script, but only a calculation, result text

[Pedropon]

you don't need a script, but only a calculation, result text

Wow, Thanks, I got it, it was to simple for my head scratching session;

" Auto-enter, Calculate Value, Do not replace..."