Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a user who wants to search a wildcard search field with multiple items.
We tried *item number1* | * item number2* | *item number3*, but had no luck.
as well as *item number1* & *item number2* & *item number3* with the same results.
It will work if we don't have the wild card search in there, but unfortunately they'll need it. Is this possible?
I was missing the () around the search criteria that's what did it for me. Thank you Sunny!
using a search expression like
=WildMatch([field name], '*item number1*', '* item number2*', '*item number3*')
might very well be an alternative solution to your question, just make sure to start with an equals sign.
hope this helps
regards
Marco