Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all -
I have a button with an action to Select in Field. I cannot figure out how to define my search substring to be a specific combination of two words. I would like to select any values within my specified field that contain the phrase "accounting department" - in that order, and only in with both words (not 'accounting', 'department', or 'department accounting'). What am I doing wrong here? Thanks!
did you try this *accounting department* ?
did you try this *accounting department* ?
Tiago - this worked beautifully. Thank you very much! Can you tell my why the second * makes the difference? I tried *accounting department before (without the second *) and it wasn't working correctly.
the first "*" mean anything before
and the seconde "*" mean anything after the key word
if you try just with first *
you would get "one acc depart" in my example, but not the "acc depart test".