Discussions

Expand all | Collapse all

Wild Card Syntax in If Statement

  • 1.  Wild Card Syntax in If Statement

    Posted 17 days ago

    What is the syntax for a wildcard in an if statement?

    For example, if I have a text field that contains multiple names, and I want to have a condition if the field contains the name Mike,

    The following returns a field with the name mike, but what if I dont care about exact match, just want it to contain that word?
    If([Text Field] = "Mike", condition, condition)

    I was hoping for something like
    If([Text Field] = *"Mike"*, condition,condition)

    That didn't work though. Can't find the correct syntax?

    Thanks



    ------------------------------
    Mike Tamoush
    ------------------------------


  • 2.  RE: Wild Card Syntax in If Statement

    Posted 17 days ago
    Of course I found my answer right after I posted. Looks like contains function is what i want. Now, how to I delete this post...?

    ------------------------------
    Mike Tamoush
    ------------------------------



  • 3.  RE: Wild Card Syntax in If Statement

    Posted 14 days ago
    Hi Mike,

    Actually it can be handy to have this around in case anyone else ends up with the same question. You are right Contains is the right formula function and for future community members with the same issue they can find out more about Contains right here in our Formula Reference Guide.

    ------------------------------
    Evan Martinez
    Community Marketing Manager
    Quick Base
    ------------------------------