Help with regex - Stop reading with specific word

I wrote this regex expression to capture anything after "Comments" and now I want to stop reading once alteryx finds "https" for instance. I saw some topics about regex but I couldn't find a way to ask alteryx to stop reading as soon as it finds "https". Any ideas on how to achieve this?

Thanks.

Workflow

Developer

Settings

Regex

Best Practices

Bug

Help

Data Investigation

Accepted answers

Jonathan-Sherman

Hi @jackersantos,

You could use the following in parse mode in a Regex tool:

Comments(.*?)https

The brackets indicate a capture group and tell Alteryx to extract the part inside, the .*? is a non greedy wildcard expression which effectively means extract everything you can find up to the next iteration of https.