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.
