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?
Solved! Go to 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 🙂
Here is an interactive lesson on the concept.
https://community.alteryx.com/t5/Interactive-Lessons/Parsing-Data-with-RegEx/ta-p/441415#done