In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Contains coding

ntudev
8 - Asteroid

Lets say i have a sentence with a word that contains 'MIT' i want to be able to only see the word that contains the 'MIT'. Example the word is Mitigate then i want to see Mitigate but if the word is also mitramachine then i also want to see it since it has MIT in it. I want to see the results in a new column. is this possible?

3 REPLIES 3
OTrieger
13 - Pulsar

@ntudev 
You can use Formula tool using Contains([field], "mit") function.
So if you will integrate into an IF formula you can say if contains then that field else null.

ntudev
8 - Asteroid

but i am just looking to see the word not the whole row. so if Submit contains MIT i just want to see the word Submit from a sentence.

apathetichell
19 - Altair

regex tool - set it up for token - split to rows (that is important)

 

use this expression

(\b\w*mit\w*\b)

 

this says - word start - at least zero word charcters mit at least zero word character - end of word. character but not the start or end of a word it won't match.

Labels
Top Solution Authors