How to extract a certain string/number?

Hi, I'm trying to figure out how to extract a certain string/number. I have a different UNIT Id, some just a string of 5 numbers some include a letter and two numbers. I have tried the following formula ToNumber(REGEX_Replace([Business unit path],"^.*?(\d{5}(.\d{1,2})?).*?$","$1")) but this gives me only a string of numbers. I have attached a picture with both values which need to be found.

Capture.PNG

Preparation

Accepted answers

Deano478

@fieldew1 if this is your data structure you can try this approach:

ID Extraction.yxmd

All comments

Deano478

@fieldew1 its very hard to help you with this issue as we cant see the rest of the string preceding the values you need can you anonymize the strings and post them here?

binu_acs

@fieldew1

fieldew1

@binuacs thank you for the solution, unfortunately, it brings back NULLS.

The string looks like below

AAAA > Newcastle > K884 - Newcastle A (121212)
BBBB> Northampton > 99863 - Northampton A (123456)

Deano478

@fieldew1 if this is your data structure you can try this approach:

ID Extraction.yxmd

fieldew1

Thank you! This seems to work

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703