Hi all,
I am trying to have a user input a string to search a field for relevant information.
So far, I was able to remove the spaces and create the syntax for the action.
For example:
User searches for:
Test two
Syntax:
='(*'&replace(vInputNew,' ','*|*')&'*)'
Output in text box:
(*Test*|*two*)
What I would like to do next:
Take the user inputs and select in field action for the relevant words in a description field.
Thanks.