extracting a part of string from the field

Question

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 Answer

Hi @simasarry123

One way of doing this.

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

Many thanks

Shanker V

binu_acs · Accepted Answer

@simasarry123 One way of doing this