AnsweredAssumed Answered

Conditional test for character string (with wildcard) in another field

Question asked by AndrewSleeth on Oct 5, 2011
Latest reply on Oct 6, 2011 by Sorbsbuster

Title

Conditional test for character string (with wildcard) in another field

Post

What's the correct syntax for a calculation field (Field_W) that displays a warning message ("STOP!") if Field_E (a text field used to store e-mail addresses) contains an address that includes a character string like "@gmail.com" or "@yahoo.com"?

In other words, how do I define a calculation field that warns when an e-mail address stored in the database is from a personal rather than a business domain?  Sort of like:

Field_W =

IF (Field_E contains ("*@gmail.com" OR "*@yahoo.com"), "Personal address!", "")

Seems like this should be simple, but I've searched FMP Help and forums for hours in vain.

--Andrew

Outcomes