Searching for team names using a common phrase

I have rows of data in the following format:

House Team 1; Some other team; Some other team; House Team M

Some other team; House Team 2; Some other team; House Team M

Some other team; House Team Earth; House Team Mercury; House Team M; Some other team

Some other team; Some other team; House Team 5; Some other team; Some other team; House Team M

I am trying to extract any team name beginning with House Team except House Team M. Any simple way of achieving this? I am on Alteryx 11.5.

Parse

Accepted answers

JosephSerpis

Hi @shehryarazhar I mocked up a workflow let me know what you think?

Regex_05062020.yxmd

JosephSerpis

Hi @shehryarazhar attached is a revised workflow should resolve cases like the example "House Team Yellow 1"

Regex_05062020.yxmd

All comments

fmvizcaino

Hi @shehryarazhar ,

You can use the regex tool to accomplish that.

Regex expression to be used: (House Team [^M;]+)

Method: Tokenize - it will get multiple occurrences in the same sentence

And please, try to update your Alteryx as fast as you can, there are a lot of great functionalities and also support from Alteryx.

Best,

Fernando Vizcaino

2020-06-05 Searching for team names using a common phrase.yxmd

JosephSerpis

Hi @shehryarazhar I mocked up a workflow let me know what you think?

Regex_05062020.yxmd

shehryarazhar

JosephSerpis.

Your solution worked. I have a couple of cases which I didn't fully account for and was hoping you can help. There are a couple of names with the convention House Team Yellow 1. The Regex only picks up House Team Yellow. What needs to be added to the Regex to pick up the number at the end of the names where available?

As you can see, I am Regex novice.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703