everyman

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?

Outcomes