SOLVED
extracting a part of string from the field
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
simasarry123
8 - Asteroid
‎05-22-2023
11:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Regex
4 REPLIES 4
ShankerV
17 - Castor
‎05-22-2023
11:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎05-22-2023
12:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-23-2023
03:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you , this worked well :) . I am yet to learn regex tool in alteryx, ( little complicated to understand).
‎05-23-2023
03:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you :) This worked perfectly in my situation.
