RegEx tool

Hello,

I need an advice how to approach the RegEx tool as it works in the exact opposite of what I need.

I have the column that contains control ID, but also a lot of comments which are before and after the ID. The id is always build like "CTRL-XXXXXXXXXX", where in the place of Xs there are always 10 digits.

I've used the regex generator, as I'm not that familiar with writing this by myself and I've tried both simplified one "CTRL-\b\d{9}\b" as well as the really rendundant one "CTRL-\d\d\d\d\d\d\d\d\d".
Both seemed to work as it catches the whole ID from the column, but as the output I receive everything beside the CTRL ID, so it's simply get trimmed from the value, is there any way to make it work in the opposite?

Thanks

Apps

Interface Tools

Accepted answers

Andrew_T-H

Try this if you're using the RegEx tool:

CTRL ID Regex101 Screenshot.PNG

^.*(CTRL-\d{10}).*$

If you are selecting the Replace option in the tool then put $1 in the replace with box

All comments

binu_acs

@Tomekt_ one way of doing this

Andrew_T-H

Try this if you're using the RegEx tool:

CTRL ID Regex101 Screenshot.PNG

^.*(CTRL-\d{10}).*$

If you are selecting the Replace option in the tool then put $1 in the replace with box

Andrew_T-H

The screenshot is from a website called RegEx 101. I find it useful to test things in there instead of running workflows over and over until I get it right.

Tomekt_

Thank you both, I managed this to work with your help, also I was struggling as I wasn't aware that in the regex tool the expression needs to be in the brackets.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703