SOLVED
Parse out number using RegEX
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
pierrejn
6 - Meteoroid
‎07-17-2023
02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need help parsing out number 3443411 using RegEX.
KM (KOOKOO MINNESOTA BATTERY SERVICES-78542-0000 (3443411))
Solved! Go to Solution.
Labels:
- Labels:
- Expression
- Parse
- Regex
3 REPLIES 3
SPetrie
13 - Pulsar
‎07-17-2023
03:05 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Assuming you are using the regex tool in parse mode, try .+\((\d+)\).*
One line is a small sample size to work with, but it should parse out that number.
flying008
15 - Aurora
‎07-17-2023
04:49 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎07-17-2023
05:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If you could provide more rows (if any), then a better REGEX pattern can also be recommended. To contribute to the above as well, you can try:
\((\d+)\)
Hope this helps @pierrejn !
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
