Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.
Jul 19, 2020 10:10 PM
Hi everyone.
I’m trying to extract a string that occurs between the same left string, but the right string has 2 possibilities
The bolded string is what I’d like to extract
VAR. 1 - between > and >
Industry > Banking & Finance > Trading (1.0)
VAR. 2 - between > and (
Industry > Banking & Finance (1.0)
Thanks a ton for your help.
Subir
Jul 25, 2020 01:21 PM
Welcome to the community, @Subir_Kumedan! :grinning_face_with_big_eyes: Here’s a formula that will do the trick. Replace {FIELD_NAME}
with the name of your field:
TRIM(MID(SUBSTITUTE(SUBSTITUTE({FIELD_NAME}, " > ", REPT(" ", 50)), " (", REPT(" ", 50)), 50, 50))
As long as the piece you want to extract is after the first “>”, this will work. If its position differs based on other conditions, it won’t.