Brian Dunning's FileMaker Custom Functions ( MyList ; FilterList )

Opposite of Filtervalues

  Average rating: 4.5 (24 votes) Log in to vote

Jonathan Jeffery   Jonathan Jeffery

Share on Facebook Share on Twitter

  Sample input: ( "A¶B¶C¶D¶E¶F¶G¶H", "A¶E¶I¶O¶U" )
  Sample output:

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This is the opposite of FileMaker's FilterValues function. It will return only the items from the first list that are *not* on the second list.



Malcolm Fitzgerald   Malcolm Fitzgerald, Wellington
Oct 7, 2016
This CF is Fastest of the "Opposite FilterValues" functions.

I ran repeated tests ( dozens, not hundreds ) on each CF.
I averaged the times and rounded down to the nearest 100ms.

1. MyList ; FilterList )
Jonathan Jeffery, igeek
~1400ms on 10,000 iterations

2. RemoveValue ( Values ; ValuesToRemove )
Koji Takeuchi, Freelance
~1700ms on 10,000 iterations

2. SubtractValues ( list ; list2 )
Jonathan Stark, Jonathan Stark Consulting
~1700ms on 10,000 iterations

3. AntiFilterValues( ListA; ListB )
Bruce Robertson, Concise Design
~5300ms on 10,000 iterations

Log in to post comments.


Note: these functions are not guaranteed or supported by Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.