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.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Under construction. Email me your wish list for improvements.