Skip to main content

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, "e^\\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?


Worked great. Thank you.

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, "e^\\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?


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 t^\\d]*$ do?

 

Thanks

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!

 

Reply


Terms & Conditions