Remove items from list: wildcard FilterValues()?

Discussion created by everyman on Feb 17, 2016
Latest reply on Feb 17, 2016 by DavidJondreau

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?