Regex a sentence containing a specific word

[DKMI]

Hi!

I am looking to pull out whole sentences from free text containing a word/collection of words

Ie:

Example string "My name is derek and I am 42. I like to alteryx designer as it is cool. I have ginger hair."

I want to pull out sentences containing 'Alteryx designer', so the result would look like:

'I like to alteryx designer as it is cool'

Any thoughts?

[binu_acs]

@DKMI One way of doing this

[davidskaife · Accepted solution]

Hi @DKMI 

Here is a way of doing it without Regex:

Use the Text to Columns tool to split by . into rows, then filter out that field where the text contains Alteryx Designer

[DKMI]

Clever! Have an excellent christmas!

[davidskaife]

Thanks, Merry Christmas to you as well!

[EN6924]

Using Text to columns -> Split to rows