Extract numbers and percentage from a string

[Chalsea]

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%

[JosephSerpis · Accepted solution]

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

[Chalsea]

@JosephSerpis Thank you so much! You ROCK!