Is there a way to construct an Advanced Filter using a contains function? I'd like to filter based on a substring being contained with a string value. I tried the obvious syntaxes, but everything I tried resulted in an error. On a Basic Filter I can choose the Contains option, but what's the syntax for using that in an Advanced Filter?
Please sign in to leave a comment.