Regex : Get Info Between 2 Words

Question

Can you help?

I want to use RegEx to get all green data between The ABC(s) the XYZ is impacting\{color\} and |*Note as shown below....

When i use regex101 with the expression below it seems to work but i cannot get Regex in Alteryx to do the same. I have attached the workflow and excel....if you could help me correct the Alteryx workflow attached to get the green data that would be great 😀

(?ms)(?<=The ABC$s$ the XYZ is impacting\{color\})(.*)(?=\|\*Note)

regex between words.yxzp

regex between words.xlsx

DataNath · Accepted Answer

Hey @DelData, in your RegEx tool configuration, your Output Method is set to Replace but you're not providing any replacement. If you want to substitute the field in place you can set the Replacement Text to '$1' - without quotes, and untick Copy unmatched text to output. If you want the replacement text as a new field, switch the Output Method to Parse and set a field name.