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é
http://Www.nicolasbourre.com

Share on Facebook Share on Twitter

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

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

Returns a list of intersecting values of two given lists.

 

Comments

comment   comment, VR
May 14, 2012
How about FilterValues():
http://www.filemaker.com/12help/html/func_ref3.33.53.html
 
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 http://www.briandunning.com/cf/39
 

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.