Regex_Parse

[Tonia_Dykes]

Hello - I am trying to extract the numbers following "LOC". The data is not consistent so I am trying to figure out the best way to do this. I have attached some data and the expected outcome. There has to be a better way LOL 

[Yoshiro_Fujimori · Accepted solution]

Hi @Tonia_Dykes ,

I hope this works for you.

Workflow

Formula tool

Output = ToNumber(REGEX_Replace([Data], ".*LOC\s?(\d+).*", "$1"))

[nagakavyasri]

Another way:

[binuacs]

@Tonia_Dykes using regex tokenize