Skip navigation

Allow wildcards and special characters in "IN" statements in filters

score 140
You have not voted. Active

The "IN" function in filters is great, but limited because you cannot use special characters ( . - , *). I would like to use it for company names, but many company names include a dash or a period.

 

Additionally, it would be great to be able to use wildcards. People can enter their company names in different ways (Acme, Acme International, Acme Inc., Acme - North Dakota). If I could include "Acme*" in a filter IN statement, it would make the IN function much more useful.

 

Right now, the only special character you are allowed to enter is a comma, and that is just as a delimiter. Instead, we could use single quotation marks and commas, or hard returns as our delimiters, so our list could look like this: "Acme","ABC Engineering","123 Company Inc."

 

or this:

 

Acme* ABC Engineering* 123 Company Inc.

Comments

Vote history