Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!
SOLVED

Extract numbers and percentage from a string

Highlighted
7 - Meteor

Hi there,

 

I try to extract numbers and percentage from the following string using regex and it didn't work.

 

I'm using RegEx within Parse tool with specific regex: ([0-9]+)(?:%) but the output show as null when I use Output Method "Tokenize" or "Parse" neither of them work. However, the regex will work in regexr.com though.

 

Can someone help me take a look? 

 

 

 

Thanks!

 

Chalsea

 

String (Rotation column):

(10/13 10%) 

10/14 - 10/31 20%)

 

Desire Output: 

10%

20%

 

Screen Shot 2020-05-27 at 1.43.11 PM.png

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Hi @Chalsea I mocked up a workflow let me know what you think?

Highlighted
7 - Meteor

@JosephSerpis Thank you so much! You ROCK!

Labels