Forum Discussion

jcaranibar's avatar
jcaranibar
Icon for Helper I rankHelper I
10 years ago
Solved

Wildcards in filter

If there are a lot of values for specific field, it is possible to use wildcards in visual level filters, like:   starts with 422??-8pp or contains 422ba-*s   Regards.   JCA
Tips and Tricks
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    jcaranibar you certainly can, make sure your column is of data type Text, drop it to filters area -> Advanced filtering and their you will have options to do that such 'contains' and 'do not contain'

ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

jcaranibar you certainly can, make sure your column is of data type Text, drop it to filters area -> Advanced filtering and their you will have options to do that such 'contains' and 'do not contain'

jeffshieldsdev's avatar
jeffshieldsdev
Icon for Solution Sage rankSolution Sage
10 years ago

But this doesn't support wildcards...any other suggestion?

  • hgorina's avatar
    hgorina
    Frequent Visitor
    8 years ago

    just enclose your expression in the filter in the single quote

    works fine with ?, but i did not test with *

     

    • hgorina's avatar
      hgorina
      Frequent Visitor
      8 years ago

      example '422??-8pp'