Alteryx Designer Desktop Discussions

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

Parse out number using RegEX

pierrejn
6 - Meteoroid

Need help parsing out number 3443411 using RegEX.

 

KM (KOOKOO MINNESOTA BATTERY SERVICES-78542-0000 (3443411))

3 REPLIES 3
SPetrie
12 - Quasar

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
14 - Magnetar

Hi, @pierrejn 

 

RegEx expression:

 

(?<=\()(\d+)(?=\))

 

 

录制_2023_07_18_07_50_25_232.gif

caltang
17 - Castor
17 - Castor

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+)\)

image.png

 

Hope this helps @pierrejn !

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels