|
»
»
»
Simple Find
|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
 |
Simple Find
by Aaron Woitkovich
::
Rate this Message:
Experts,
I am working with an FMP8 file that has a text field called "email". If you search by the characters to the left or right of the "@" sign, the correct results are displayed. For example, if the email field contained: adw@... <mailto:adw@...> , a search on "adw" or "abc.com" would return this record, but a find for adw@... <mailto:adw@...> would produce an error saying no matching records could be found. I'm sure this has been a problem for a while, I just never noticed it. Thanks for any assistance. -Aaron _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
RE: Simple Find - solved
by Aaron Woitkovich
::
Rate this Message:
All, I guess i posted this to soon. If anyone is wondering, you need to put the @ sign in quotes. So, the correct find would be: adw"@"abc.com Thanks again, Aaron Experts, I am working with an FMP8 file that has a text field called "email". If you search by the characters to the left or right of the "@" sign, the correct results are displayed. For example, if the email field contained: adw@... <mailto:adw@...> , a search on "adw" or "abc.com" would return this record, but a find for adw@... <mailto:adw@...> would produce an error saying no matching records could be found. I'm sure this has been a problem for a while, I just never noticed it. Thanks for any assistance. -Aaron _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Simple Find
by Darren Terry-3
::
Rate this Message:
On Jul 22, 2008, at 1:33 PM, Aaron Woitkovich wrote: > I am working with an FMP8 file that has a text field called "email". > If you search by the characters to the left or right of the "@" sign, > the correct results are displayed. > > For example, if the email field contained: adw@... > <mailto:adw@...> , a search on "adw" or "abc.com" would return > this record, but a find for adw@... <mailto:adw@...> would > produce an error saying no matching records could be found. > > I'm sure this has been a problem for a while, I just never noticed it. Hi Aaron: Enclose the email address in quotes, and it works. regards, Darren ****************************** Darren Terry darren_terry@... Pacific Data Management, Inc. http://www.pdm-inc.com/ 111 W. St. John St. Phone: (408) 283-5900 x303 Suite 404 Fax: (408) 283-5903 San Jose, CA 95113 ***** FileMaker 9 Certified Developer ***** _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Simple Find - solved
by Beverly Voth-2
::
Rate this Message:
Or escape it with backslash:
aaron\@cannonfinancial.com Beverly Voth On 7/22/08 4:38 PM, "Aaron Woitkovich" <aaronw@...> wrote in whole or in part: > > All, > > I guess i posted this to soon. If anyone is wondering, you need to put > the @ sign in quotes. So, the correct find would be: adw"@"abc.com > > Thanks again, > Aaron > > > > > Experts, > > I am working with an FMP8 file that has a text field called "email". > If you search by the characters to the left or right of the "@" sign, > the correct results are displayed. > > For example, if the email field contained: adw@... > <mailto:adw@...> , a search on "adw" or "abc.com" would return > this record, but a find for adw@... <mailto:adw@...> would > produce an error saying no matching records could be found. > > I'm sure this has been a problem for a while, I just never noticed it. > > Thanks for any assistance. > > > -Aaron > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Simple Find - solved
by Jonathan Fletcher
::
Rate this Message:
Aaron, that's because the "@" is an operator you can use when you
create searches. j. On Jul 22, 2008, at 4:44 PM, Beverly Voth wrote: > Or escape it with backslash: > > aaron\@cannonfinancial.com > > Beverly Voth > > On 7/22/08 4:38 PM, "Aaron Woitkovich" <aaronw@...> > wrote in > whole or in part: > >> >> All, >> >> I guess i posted this to soon. If anyone is wondering, you need to >> put >> the @ sign in quotes. So, the correct find would be: adw"@"abc.com >> >> Thanks again, >> Aaron >> >> >> >> >> Experts, >> >> I am working with an FMP8 file that has a text field called "email". >> If you search by the characters to the left or right of the "@" sign, >> the correct results are displayed. >> >> For example, if the email field contained: adw@... >> <mailto:adw@...> , a search on "adw" or "abc.com" would return >> this record, but a find for adw@... <mailto:adw@...> would >> produce an error saying no matching records could be found. >> >> I'm sure this has been a problem for a while, I just never noticed >> it. >> >> Thanks for any assistance. >> >> >> -Aaron >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au >> _______________________________________________ >> FMPexperts mailing list >> FMPexperts@... >> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au > > > _______________________________________________ > FMPexperts mailing list > FMPexperts@... > http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au -- Jonathan Fletcher jfletch@... Project Foreman NewMedia Construction Co. _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Simple Find - solved
by Eric Scheid-2
::
Rate this Message:
On 23/7/08 7:16 AM, "Jonathan Fletcher" <jfletch@...> wrote:
> Aaron, that's because the "@" is an operator you can use when you > create searches. A symbol which matches any indexed character (which by default doesn't include punctuation marks, such as "@"). Enclose the search criteria in quotes, or turn on ASCII indexing for that field (the latter not recommended, as it then becomes case sensitive for searches). e. _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
|
|
Re: Simple Find - solved
by Beverly Voth-2
::
Rate this Message:
OR, in FMP9, use the "escape character" ("\") before the "@":
name\@domain.com This is helpful if you need to find parts of email addresses, "\@domain", for example. Beverly On 7/22/08 7:20 PM, "Eric Scheid" <genius@...> wrote in whole or in part: > On 23/7/08 7:16 AM, "Jonathan Fletcher" <jfletch@...> wrote: > >> Aaron, that's because the "@" is an operator you can use when you >> create searches. > > A symbol which matches any indexed character (which by default doesn't > include punctuation marks, such as "@"). Enclose the search criteria in > quotes, or turn on ASCII indexing for that field (the latter not > recommended, as it then becomes case sensitive for searches). > > e. _______________________________________________ FMPexperts mailing list FMPexperts@... http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au |
| Free Forum Powered by Nabble | Forum Help |