SWITCH formula If

[Jeffpdoes]

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.

[Justin_Barrett · Accepted solution]

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"
    )
)

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

[Jeffpdoes]

Justin_Barrett:

[^\\d]*$

Worked great. Thank you.

[Jeffpdoes]

Hi Justin, you helped me out with this previously.  The source material this year is formatted slightly differently, and I can't seem to get it to work.  Here's an example of the source:

63101156321; 05945; 5574; ; ; 5574COMBS,GORDON

And I would like the formula to output "Gordon"

In addition what does the [^\\d]*$ do?

Thanks

[Jeffpdoes]

I got it working.  In my attempts I must have mis-typed something which mistakenly led me to believe my solution didn't work.  Thanks again!