Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Wild Card characters and Filters

Issue

Wild card filters (the asterisk * and question mark ? ) cannot be used as part of a range filter when you are trying to exclude the elements of the range.

For example:

"<>A*..C*"

"<>A?..B?"

are two examples for non-valid filters.

filtererror.png

Solution:

To create a filter that will exclude everything starting with A through C, think of the filter as including everything except the things starting with A through C.

When you think of the filter as including values, then "D.." is the filter you could use.

Alternately, the filter "<>A*&<>B*&<>C*" would also work for this example since no ranges are involved.

Published:

Wild Card characters and Filters

Issue

Wild card filters (the asterisk * and question mark ? ) cannot be used as part of a range filter when you are trying to exclude the elements of the range.

For example:

"<>A*..C*"

"<>A?..B?"

are two examples for non-valid filters.

filtererror.png

Solution:

To create a filter that will exclude everything starting with A through C, think of the filter as including everything except the things starting with A through C.

When you think of the filter as including values, then "D.." is the filter you could use.

Alternately, the filter "<>A*&<>B*&<>C*" would also work for this example since no ranges are involved.

For an optimal Community experience, Please view on Desktop