RegEx Certain Words

I have the below coming out of our database and I need to separate each phrase into a new column. 'Wants' is a common word to the start of each phrase so I have been trying RegEx to try and get the desired outcome.

Input:
Wants more details on this property Wants to view this property Wants an online viewing Wants more details on this property Wants to view this property

Output:

Wants more details on this property

Wants to view this property

Wants an online viewing

Wants more details on this property

Any advise on the expression to use would be appreciated. Thank you

Regex

Accepted answers

atcodedog05

Hi @tf05

Here is how you can do it.

Workflow:

Hope this helps : )

wants.yxmd

binu_acs

@tf05 similar to @atcodedog05 solution but using regex tokenize

regex18.yxmd

All comments

atcodedog05

Hi @tf05

Here is how you can do it.

Workflow:

Hope this helps : )

wants.yxmd

atcodedog05

Happy to help : ) @tf05

Cheers and have a nice day!

binu_acs

@tf05 similar to @atcodedog05 solution but using regex tokenize

regex18.yxmd

MarqueeCrew

@tf05 ,

In reviewing your post, I didn't see a solve that helped to explain the solution. I've posted a YouTube video and will include a brief narrative here.

Essentially you want to list the demands (wants) included in your input as single asks. For the sample data, each request starts with Wants. But "certain words" leads me to thinking that there could be other text. If we limit ourselves here to the string having a Capital letter to begin each sentence, we can parse the data.

I'll demonstrate a non-RegEx way to do this for "FIXED" strings. I'll then move to how to get to the final solution via RegEx. I'll use a TRIAL & ERROR approach. Nothing is as easy as looking at a final solution, but knowing that it got there on a bumpy path might make you see that learning is something to share.

Here's the video followed by a picture followed by CHEERS 🍻 followed by a workflow.

RegEx Certain Words.yxmd

atcodedog05

Hi @MarqueeCrew

Noted, thanks for the improvement tip. I realized about this mistake after seeing @binu_acs solution 😅

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335