The Inspire Pin contest has begun! Win a free pass to Inspire by submitting your design to be made into a real-life pin! Submission details can be found here.

community Alteryx Academy MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Extract number from string

CO
6 - Meteoroid
‎01-30-2018 08:09 AM

Hello, 

Apologies because I have seen more posts similar to this one but I don't clearly see how the RegEx tool works.

I would need to extract the number from a column that follows the attached format.

How could I get it?

 

Thank you

sample.txt
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
LordNeilLord
15 - Aurora
‎01-30-2018 08:15 AM

Hey,

 

Try this regex:

 

\((\d.+)\)\.jpg

regex.PNG

Reply
CO
6 - Meteoroid
‎01-30-2018 08:19 AM

Thanks for the quick and effective response!

Reply
0 Likes
Community Live building your first workflow
Labels