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.

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: