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

    Remove items from list: wildcard FilterValues()?


      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?