Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
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