Airtable Formula

Hey @M_k!

Try this formula format:

REGEX_EXTRACT(
    SUBSTITUTE(
        {Label},
        " ",
        ""
    ),
    "[A-Za-z0-9]*"
)

It will produce something like this:

Let me know if you have any issues, questions, or just want a wider explanation!

@Ben.Young The requirement was to remove all characters after the space. Yours removes the space and the extension, but keeps the characters after the space.

@M_k This will do what you want:

IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

Thank you so much, @Justin_Barrett and @Ben.Young!!

It’s the formula output from Justin’s, that will work for my use case. TY

Mary

@M_k You can also do this without using REGEX at all:

LEFT(text,FIND(" ",text)-1)

IF(Label, REGEX_EXTRACT(Label, "[^ ]*"))

Oops - I guess killing time on the forums late at night might not be the best idea for me lmao.