Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Product Spotfire
Categories Filters
Created by Guest
Created on Mar 26, 2020

Quoting of parentheses in text filters, single character wildcard

I often use text filters where I have strings like "xxabc(22)_cde" in all kinds of different combinations. Searching in these strings is a pain for me.

Take for example xxabc(20)_dd_ffj(22)_bla. I want a possibility to match for the j(22). The way to do this seems to be "*j(22)". In principle this is fine, but you cannot do the nice stuff like "*(j or c)(22)" with this which is really annoying.

To get rid of these issues, please introduce a simple \( or another quoting mechanism to match the literal (, of course also the corresponding \). In the beginning I thought "(" would do the trick but it doesn't, *j"("20")" matches the above example.

In addition, a wildcard which matches exactly one character would be great. How about the ? together with \? for quoting...

  • Attach files
  • Guest
    Reply
    |
    Jun 24, 2020

    Can you not use the regular regex expression? Very powerful for string tests?
    [Column]~=".j\(22\)" or [Column]~=".c\(22\)"would be true if the string contained j22 or c22.

    (Case sensitive)

    The \ escapes the "(" and ")"