Conditional test for character string (with wildcard) in another field
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:
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.
PatternCount ( Field_E ; "gmail.com" )
PatternCount ( Field_E ; "yahoo.com" ) ;
"Personal address!" ;