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 · Accepted solution]

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 🙂

[atcodedog05]

Here is an interactive lesson on the concept.

https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415#done