Find with '@' problems

[Greg O'Connor]

I am not able to perform a 'Find' on a field containing email addresses. Are there any restrictions / secrets in FMP with the '@' sign?

Any information or workarounds would be appreciated.

Greetings

Greg

[comment]

Are there any restrictions / secrets in FMP with the '@' sign?

Yes.

http://www.fmforums.com/forum/showpost.php?post/234328/

[Greg O'Connor]

Thanks, I read this and understand.

Does this mean I cannot use email addresses as a user name? Specially in a web connected database?

Is it still possible with a work around? Is there any custom function?

Cheers

Greg

[comment]

Does this mean I cannot use email addresses as a user name?

I don't see why not.

Is it still possible with a work around? Is there any custom function?

All you need to do is escape the @ character when searching for it. I wouldn't call this a workaround, and no custom functions are required, IMHO.

[Greg O'Connor]

I assume the escape function is JavaScript and not a FMP function and needs to be in the web query form.

If so, I guess I need a need a new searchable FMP field where the @ has been substituted?

Am I on the right way or would you suggest something else?

Greg

[comment]

I assume the escape function is JavaScript

I assume you haven't read the relevant section in Filemaker help, as was suggested in the post I have linked to.

[Greg O'Connor]

I did browse it, now read it again, but cannot fond any 'escape' item.

I might not have understood correctly when you said '...you need to escape the @ character..'

Greg

[comment]

To find:

A character with special meaning, such as the find symbols recognized by FileMaker Pro:

@, *, #, ?, !, =, <, >, "

Type this in the field:

followed by the special character

Examples:

"Joey" finds "Joey"

[email protected] finds the email address [email protected]

True, it doesn't use the term "escape" (though you will find it used elsewhere).

[Greg O'Connor]

Thanks.

I learned a lot from this and it works fine.

Cheers

Greg