Contains coding

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?

Developer

Output

Common Use Cases

Optimization

Accepted answers

apathetichell

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.

All comments

OTrieger

@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

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703