Skip to main content

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




  1. VAR. 1 - between > and >

    Industry > Banking & Finance > Trading (1.0)




  2. VAR. 2 - between > and (

    Industry > Banking & Finance (1.0)




Thanks a ton for your help.

Subir

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.

Reply


Terms & Conditions