Skip to main content

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

Hi,

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.


RIGHT(Name,-FIND('CUT',

  SUBSTITUTE(Name,'-','CUT',2)

)+LEN(Name))

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


\w+$

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


\w+\s\w+$

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


\w+\s\w+$|\w+$

Let me know if that works!

Thank you!! It worked perfectly! 🙂

Reply


Terms & Conditions