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?
@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.
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.
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
