I am running into a glitch that I can't remember how to work around.
Trying to search a fileMaker data source on an email field.
The "@" character in filemaker is a wild card, so I have to search on the
literal characters by enclosing the search criteria in quotes to force fmp
to not look at the @ in the email address as a wild card.
When I do a search in fmp, I would write it like this: "[EMAIL PROTECTED]"
(note the quotes)
In tango (4.0.136 mac) I do not have the option to quote value in the search
criteria action. I am experimenting with adding quotes around the <@ARG> but
no combination seems to be working.
Here is the tag I need to quote: <@LOWER STR='<@ARG EMAIL_ADDRESS>'>
Tried these options with no luck:
<@DQ><@LOWER STR='<@ARG EMAIL_ADDRESS>'><@DQ>
"<@LOWER STR='<@ARG EMAIL_ADDRESS>'>"
I suppose I could add the quotes to the <@ARG> before the search action, but
I'm hoping there is a simpler solution.
Can someone point me in the right direction? Thx!
--> [groundZER�]
--> [t:o:m:c:a:r:r]
--> [[EMAIL PROTECTED]]
--> [847:757:4188]
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
