Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

REGEXMATCH to find word and numbers

Shibiko
6 - Meteoroid

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

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @Shibiko 

 

Try this:


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

 

Cheers,

Shibiko
6 - Meteoroid

Perfect, thank you!

Labels