Regex : Get Info Between 2 Words

[DelData]

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)

 

[DataNath · Accepted solution]

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.

[DelData]

Thanks DataNath....

this works and exactly what i needed.....i getting a bit better at RegEx with many near misses 😀

Thanks for taking time out to help me fix this issue 👍