03-04-2015 09:40 AM
Is there a way to set up an advanced text filter that would return all text cases for a particular word without having to enter all the alternatives.
For example: <text category> does not contain "dog" (any case) - this should exclude all text for dog DOG Dog or DOg. Is there an operator that can do this?
03-04-2015 09:53 AM
A number of functions (e.g., find and the regex functions) contain a modifier that ignores case.
Didn't realize that you asked this in regard to VA. Couldn't you edit the sql expression to apply the UPCASE function to the variable name?
03-04-2015 11:14 AM
Yes thanks, this is for VA 7.1. So your saying import all sql text as upcase? I'd prefer to just deal with however the data appears on the SQL side as in some cases there may be a distinct difference and I'd rather not set an ETL import rule like that. I'd like to just use a single function in my filter that will ignore case. As it is, I am entering multiple word filters to cover the most common case formats.
03-04-2015 11:26 AM
No, but I've never used VA. However, according to the documentation: 4 (Optional) You can click the Functions tab and select the functions to use with filtering.
I think that you only need to use the function UPCASE.
03-04-2015 11:45 AM
You can set up an advanced filter to do this kind of operation. I have used something similar (i believe) to allow users to use a smart search function. Set up a parameter and then link this to an input box. Drive the advanced filter from this imput box (the parameter). In the advanced filter you can the add 'upcase' of whatever you need.
This is a screenshot of what I think you need to explore:
03-10-2015 04:23 PM
Thanks Max. I'll check it out. Where would the input box appear? Is it just in the Adv Filter screen or does it appear somewhere in the Exploration right window?