Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do i extract numbers from text?

124 1
cancel
Showing results for 
Search instead for 
Did you mean: 

chrome_FyF8uhC5J1
how do I extract the numbers before the first delimiter"|"?

1 Reply 1

Welcome to the Airtable community!

I suggest looking into the REGEX_EXTRACT() formula function. It is documented in the Formula Field Reference.

The exact pattern to use depends on whether you want all the digits before the delimiter, or just one group, and what to do with letters between the digits and the delimiter.

Building a REGEX pattern can be tricky. I recommend using a free online REGEX testing website to experiment with different patterns until you find one that works for all your use cases.