extracting a part of string from the field

[simasarry123]

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?

[ShankerV · Accepted solution]

Hi @simasarry123 

One way of doing this.

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

Many thanks

Shanker V

[binu_acs · Accepted solution]

@simasarry123 One way of doing this

[simasarry123]

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

[simasarry123]

Thank you :) This worked perfectly in my situation.