I used one of the discussion topics to re-create, and have a regular expession search box working in a report.
The thing is that the expression matches only on the end of the AccountName string value.
Example:
My QuickFilter for AccountName used the follwing code:
If REGEXP_MATCH([AccountName],[Regex]) = True then [AccountName] END
When the content of my Quick Filter is: INC$ the QuickFilter returns only the records with INC as the end of the AccountName
IT returns XXXXX Company INC with no issues....
It DOES NOT return XXXXX INC Company....
I need the code to return AccountNames where INC is present, regardless of location, in the AccountName.
Tableau 9.0
TIA, Jay
Hi Jay
I'm new to regular expressions and they are a bit cryptic.
Agree I haven't even used reg_ex expressions...
I have it working fine, just need to figure out the regular expression that lets me replace inc$ (Returns names with inc as the last 3 chars with something like *inc* that returns any account name where 'inc' is in the account name.
but it sounds like you want to use a wildcard
This is useful > Become a regular with regular expressions
and it has links to various reg expression builders RegExr: Learn, Build, & Test RegEx which help you construct the expression
Also, I found this on Wikipedia Wildcard character - Wikipedia, the free encyclopedia
Hope that helps a little!
Cheers
Mark
