Regex containing word

[krishnagandhi]

Hi,

I am trying to use the regex match function to basically return me a true whenever the word "training" appears in a field. It could be at the beginning, middle or end of the field and i can not for the life of me figure it out. I tried a contains function as well but that didn't seem to work either. I have attached the workflow. any help would be appreciated.

Thanks,

Krishna 

[fmvizcaino · Accepted solution]

Hi @krishnagandhi ,

You can use the following function Contains([CATS Short Text], 'TRAINING')

It will return -1 if true and 0 if false.

Best,

Fernando Vizcaino