Regex a sentence containing a specific word

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?

Regex

Accepted answers

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 One way of doing this

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

Clever! Have an excellent christmas!

Using Text to columns -> Split to rows