Airtable Formula

[M_k]

Hi Airtable!

I am trying to figure out how to create a formula for a string.

I would like to remove everything after the first set of numbers, with no spaces:
1234 56.jpeg
1234a 56.jpeg

to:
1234
1234a

Can someone help me?

Formulas are not my strong suit.

Mary

[Ben_Young1]

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!

[Justin_Barrett]

@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, "[^ ]*"))

[M_k]

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

[ScottWorld]

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

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

[Ben_Young1]

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