community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Regex Parse Behaves Unexpectedly when using '|' (OR) operator

I am parsing retailer promotions and have two input strings:

1. take a further 10%
2. take an additional 10%

 

I am using the regex parse tool to parse out the discount value, using the following regex:

further|additional (\d+)%

 

When the input contains examples of both options (i.e 'further' and 'additional'), the tool only seems to parse the first one encountered.

 

E.g if I state the regex string as:

further|additional (\d+)%

 

It only parses line 1 above

 

And if I state the regex string as:

additional|further (\d+)%

 

It only parse line 2