Every time I try to do a search on an email address (using the entire email address) it doesn't work. If I just use the address part before the @ sign it does work. How can I do a search on the entire email address.
Since the '@' symbol is a search parameter itself in Filemaker, you cannot really perform a search on it.
There are several ways to get around this. Here's one.
What you could do however is create a dummy field that matches the email field, except it subsitutes the '@' symbol for something else, for example 'zzz'. You don't show this field anywhere, you just keep it in the background, and use it only when you're searching for an email (in a script).
Then when you search for an email -- you set up a script that takes your search parameters (for example: 'firstname.lastname@example.org') -- it then sets a variable to take your search entry and makes it into 'johnzzzemail.com' -- and uses that variable value to search on your dummy field. That way it will avoid trying to perform a search with the @ symbol.
Put it in quotation marks.
When searching for an email address you can try the following:
1 - enclose the email address on double quote marks, e.g. "email@example.com"
2 - type 2 equal signs before the email address, e.g. ==firstname.lastname@example.org
Either of these should work for you. The "@" symbol is a wildcard character when used in a Find which is why the literal search for an email address doesn't work.
The online help has some good tips about performing finds in FileMaker Pro:
FileMaker 8/9/10/11 Certified Developer
- - - - - - - - - - - - - - - - -
Phone: +61 2 9484 6565
Mobile: +61 418 468 103
The @ is a special character and needs to be escaped when used literally in search. To find the email address email@example.com search for:
databuzz wrote: The online help has some good tips about performing finds in FileMaker Pro: http://www.filemaker.com/11help/html/find_sort.5.6.html#1027771
Indeed it does - and this exact question is covered in the 9th row of the examples table.
Retrieving data ...