Skip to main content

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

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


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


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)


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


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


Reply