extract text from a string that is between _ (underscore)

Neffri

Hello,
I'd like to separate the text which is between two  underscores.
For example:
Manager Review and Revocation_CYBERSECURITY & TECH CONTROLS_

I want to get CYBERSECURITY & TECH CONTROLS.

I've tried to use Text to column, but do you know if there is  a better way to do it?

Any suggestions?

atcodedog05

Hi @Neffri 

You can use Regex tool parse mode and regex formula below to extract it.

_(.*)_

In the formula it captures everything between brackets

Workflow:

Hope this helps 🙂

extract.yxmd