2 Replies Latest reply on Feb 17, 2016 3:33 PM by DavidJondreau

    Remove items from list: wildcard FilterValues()?

    everyman

      Probably another one of those "I'll kick myself for asking" questions, but: Does anyone have an elegant way (calculation or custom function) to remove "mostly matching" items from a list?  Here's what I mean:

       

      Widget 1

      Gadget 2

      Widget 2

      widget 3

      Gadget 5

       

      I want to remove all "gadget" items from the list.  FilterValues() almost does it, if only I could wildcard it:

       

      FilterValuesWild ( $myList ; "Widget *")

       

      Similarly, a "negative" FilterValues() that returns everything NOT in the filter would be helpful, too.

       

      Surely this isn't an off-the-wall request?