SWITCH formula If

I’m trying to create a SWITCH formula checking for specific text within a field.
For instance, if there is a field with a bunch of random numbers and then a name, I want to check for the name in that field, not match the entirety of the text in the field.

Assuming that there’s nothing after the person’s name that needs to be omitted/ignored, this formula that uses a regular expression to extract only the name will work:

IF(
    Source,
    SWITCH(
        REGEX_EXTRACT(Source, "[^\\d]*$"),
        "Bob", "Bob's output",
        "Jake", "Jake's output",
        "Arnold", "Arnold's output"
    )
)

Screen Shot 2021-12-28 at 2.01.28 PM

If the source material is more complex, could you share a sample?

1 Like

Worked great. Thank you.

1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.