Regex Match Not working

[don_sevcik]

I'm scanning a list of tweet in Alteryx.  The data comes back fine.

Using the Regex Tool, I want to filter those tweets by any username containing the word Broker or broker.

I tried:  /[Bb]roker/ and [Bb]roker in the Regular Expression field and for both instances, I get 0 matches. I can clearly see my dataset has usernames with the word Broker in them.

Do I need something else?

[jdunkerley79 · Accepted solution]

I'd probably use a Filter tool on contains mode. But if you want to use a Regex tool in match mode I think you need .* before and after the target to match, i.e. .*[Bb]roker.*

[don_sevcik]

The .* enclosure worked! Thanks!