Regex statement to obtain data between 2 specific words.

[Faresghnaim]

Hi guys!

I have a huge text file and I would like to get all the data between 2 specific strings which are "Ready" and "Commit" for example:

Ready the id for the user is 241 Commit 

Ready the email is john@example.com Commit 

If I want to get the data between those 2 specific no matter what it is, which regex statement could I use?

Thanks a lot!

[atcodedog05 · Accepted solution]

Hi @Faresghnaim 

Here is a regex for the job.

Use below config in Regex tool.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05 · Accepted solution]

Hi @Faresghnaim 

Another scenario considering the data is not broken into rows.

Input:

Output:

Workflow:

This might more suit your text file scenario. Please check and let me know 🙂

[atcodedog05]

Happy to help 🙂 @Faresghnaim 

Cheers and Happy Analyzing 😀