Searching for team names using a common phrase

[shehryarazhar]

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.

[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

[JosephSerpis · Accepted solution]

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

[shehryarazhar]

Thanks @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. 

[JosephSerpis · Accepted solution]

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

[shehryarazhar]

Thanks that worked perfectly.