Hello everyone; Does anybody know how to find for example only "ture" in the following string" "screen shots or pictures of errors with ture and ..." I tried many available functions, but non of them worked as they need location of the word. But since I'm dealing with over 100 milion observation and the location of the word in variable (column) is random, I can't get any useful results. For example, if I want to use index or Find or Contains, then I get pictures and ture, because pictures also contains ture. If I want to use SUBSTR instead then I need to know the location of the word, which I don't because the word can be found anywhere in the column. Any help would be appreciated very much. Thanks!
... View more