1 Reply Latest reply on Oct 6, 2011 1:39 AM by Sorbsbuster

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

    AndrewSleeth

      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