How do i extract numbers from text?

734 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.