Hi, I need some help modifying a formula in the select statement. There are other parameters involved (like CaseSense) but the main one I'm focused on now is "Keyword". I want to add a second parameter (Keyword2 and maybe even Keyword3) to this. I want these to be using the "OR" operator. Can someone provide the change for this?
Just a little background on this report we are using. This basically searches one of the fields for specific keywords. You can use ? or * as wildcards currently but it doesn't support searching multiple keywords throughout the report. It will only search for consecutive keywords (which is good also and we want to keep that). I want to give the end users the option to search for multiple keywords throughout the report also though.
I have one more additional request. How much more difficult is it to put logic in so it will take symbols (like ||
) instead of using the OR operator? So instead of using multiple "Keyword" parameters, I want to keep it currently at one but add some logic into it so if the user puts in specific characters or symbols, it will pick it up as an AND or OR operator. For example, if they put in "apples||oranges" it will search for apples or oranges...or "apples&&oranges" will search for reports that contain both words.
Attached is a sample text of the formula currently used in the select expert.