Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to search for " PUSH " and " PER " and I want to include the space at the front and back to make sure I only get the single word, but when I add the wildcard * to the mix so that I can search within a text string I can't get the filter to work. Can someone help with the correct syntax. I have tried the 3 following options which seem to be the most logical, but none work. I have also tried some variations with single quotes with no luck.
(* PER *|* PUSH *)
("* PER *"|"* PUSH *")
(*" PER "*|*" PUSH "*)
I am also applying the UPPER() function to the Field to ignore the case sensitivity, could that be what is causing the problem?
Thanks!
The middle one seems to work for me:
("* PER *"|"* PUSH *")
Thanks! Apparently it was the button action that wasn't triggering, I moved the action to a text box and it worked
Awesome
I am glad you were finally able to figure it out.
Best,
Sunny