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?
Solved! Go to Solution.
@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.
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.
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.
User | Count |
---|---|
18 | |
14 | |
10 | |
6 | |
6 |