Extract from a text column all the words in each line containing a certain pattern

Problem Description:

I want to extract from a text column all the words in each line containing a certain pattern (this pattern could be defined as a fixed word, a regex, or other). The result of this extraction would create a new column and place the words identified as following this pattern.

Solution:

The search / replace function supports regex, including capture groups:

This will give in preview:

A validation rule allows filtering and for example to apply the search/replace only on the values that match a certain requirement:

Then all you need to do is apply a filter: