Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Airtable Formula

Topic Labels: Formulas
421 5
Showing results for 
Search instead for 
Did you mean: 

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


Can someone help me?

Formulas are not my strong suit.


5 Replies 5

Hey @M_k!

Try this formula format:

        " ",

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

Screen Shot 2022-03-12 at 11.06.34 PM

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


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

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

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