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

Extract text after second character

Topic Labels: Formulas
217 3
Showing results for 
Search instead for 
Did you mean: 

Hi can someone help me to extract the TEXT3 after the second " - "

I’ve tried this formula but haven’t been able to reference the second " - "

IF({Engineer + Seniority + Direct Manager}, REGEX_EXTRACT({Engineer + Seniority + Direct Manager}, “(?:\- )(.*)”))

Text sample: TEXT1 - TEXT2 - TEXT3

3 Replies 3

i’m too sleepy to regex now, at morning
so i crafted this.
also, you can change a number (2) to cut after third, fourth occurence etc.


If it’s always one word at the end, Regex would work like this:


$ matches the end of the string. If there would always be two words, Regex looks like this:


and if it can be both, you can use an alternation (“|”) in between those two:


Let me know if that works!

Thank you!! It worked perfectly! :slightly_smiling_face: