Brian Dunning's FileMaker Custom Functions

FilterListItems_Filtrate.cf ( MyList ; FilterList )

Opposite of Filtervalues

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

Jonathan Jeffery   Jonathan Jeffery
igeek
http://www.igeek.co.uk

Share on Facebook Share on Twitter

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

  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.

 

Comments

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. FilterListItems_Filtrate.cf( 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 BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.