Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 22, 2023 12:56 AM
Hello the community!
I'm trying to do an extraction from a text but I can't get it
My Initial text looks like that :
RP-34, CP-4554, IO-34, REQ-455, DK-344, REQ-44, REQ-404, FG-34
and I would like to export the list of items with REQ to have this result:
REQ-455, REQ-44, REQ-404
Does anyone have an idea of what formula to use? 🙄
Thanks a lot!
Feb 22, 2023 08:00 AM
There are several different ways to approach this, but the one to use depends upon where the initial text is coming from. Is it a text field, a rollup, or an array of some sort?
Feb 22, 2023 08:12 AM
Hi Ron_Daniel,
The inital text is a text field 🙂
Feb 22, 2023 08:45 AM
I've approached this from quite a few angles and unfortunately Airtable has some limitations when it comes to regular expressions. Are the numbers after REQ- always two or three digits? If not, what would their range be?
Feb 22, 2023 08:51 AM
Yes I have always a number after REQ-
Could be 1 to 5 digits 🙂
Feb 22, 2023 09:18 AM
The regular expression to grab the "REQ-" with 1-5 numbers after it would be
Feb 23, 2023 12:14 AM
Thanks a lot for your time and help Ron_Daniel !
Does anyone have an idea?