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