Help with regex - Stop reading with specific word

[jackersantos]

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.

[jackersantos]

Please ignore the "/webapp". It was just some testing I was doing

[fmvizcaino]

Hey @jackersantos ,

You can put everything you want between parenthesis.

(\W+Comments\D.+)?HTTP

Best,

Fernando Vizcaino

[Jonathan-Sherman · Accepted solution]

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.

Kind regards,

Jonathan

[jackersantos]

Thank you very much!

[Jonathan-Sherman]

No problem!