I need to find the records that matches a string. I am using 'contains' function but it's not fetching me any results.

Any idea on how can I get the records matching a string.

If contains([Description],"string with spaces and multiple sentence") then 'yes' else 'no' end

CodePudding user response：

I tried a similar way, the trick is how you draft the text inside the double quotes

This Worked!!!