Brian Dunning's FileMaker Custom Functions

list.intersect ( listA ; listB )

Returns the intersection list from listA and listB

  Average rating: 3.8 (49 votes) Log in to vote

Nicolas Bourré   Nicolas Bourré

Share on Facebook Share on Twitter

  Sample input:
list.intersect ( "a¶b¶c"; "b¶c¶d")
  Sample output:

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

Returns a list of intersecting values of two given lists.



comment   comment, VR
May 14, 2012
How about FilterValues():
Nicolas Bourré   Nicolas Bourré
May 15, 2012
Hmmmm... Neverthough of using about this one! :|

Why they don't name functions for what they are...
Dave   Dave, Birmingham, AL
Feb 23, 2016
What might you do to generate the inverse?

Sample Input: list.intersect ( "a¶b¶c"; "b¶c¶d")

Sample Output: a¶d
Scott Rose   Scott Rose, Austin, TX
Oct 9, 2016
To generate the inverse, try XORvalues at

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.