How to extract text

Hi, I have a list of cities and states, and I want to extract only first state initials. How can I do that?

image

Thanks

Hey @Michael1!

I had a similar use case a long time ago.
Here’s the formula I used back then:

(I added in your field name {City/States})

TRIM(
    SUBSTITUTE(
        REGEX_EXTRACT(
            {City/States},
            "(,\s..)"
        ),
        ",",
        ""
    )
)

Now, there is a something important to note.
This (specific) formula only works if you have a comma and a space before the state code.

This requires that you must have consistent and clean data in order for the formula to be consistent.

1 Like

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