In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

extracting a part of string from the field

simasarry123
8 - Asteroid

I have various fields with wordings " spouse of ID 344500 "  . I want to extract the numerical part of this field which is 344500. The position of this number may not be same in all fields . In some cases it could be 344505 - Spouse ID or something like Spouse of ID - 344055.

 

How can I just extract the number from such fields?

4 REPLIES 4
ShankerV
17 - Castor

Hi @simasarry123 

 

One way of doing this.

 

ShankerV_0-1684780242891.png

 

.{0,}(\d{6}).{0,}

 

ShankerV_0-1684780342456.png

ShankerV_1-1684780373616.png

 

Many thanks

Shanker V

binuacs
21 - Polaris

@simasarry123 One way of doing this

binuacs_0-1684785377680.png

 

simasarry123
8 - Asteroid

Thank you , this worked well :) . I am yet to learn regex tool in alteryx, ( little complicated to understand).

simasarry123
8 - Asteroid

Thank you :) This worked perfectly in my situation. 

Labels
Top Solution Authors