REGEXMATCH to find word and numbers

[Shibiko]

Hi, 

I'm trying to use RegEx to find a specific word and number of digits within a string, here is an example:

1513720BR Finance Store 1932 Analyst

So  I need find \<\Store+\> and numbers that follow, they could be 4 digits or less 

I cannot figure out how to do this in one formula tool, please make a suggestion

[Thableaus · Accepted solution]

Hi @Shibiko 

Try this:

REGEX_Replace([Field1], ".*(Store\s\d+).*", "$1")

Cheers,

[Shibiko]

Perfect, thank you!