Brian Dunning's FileMaker Custom Functions

FilterOut ( ListA ; ListB )

Filter the values of Lists out of ListA

  Average rating: 3.0 (1 vote) Log in to vote

Jul Carson   Jul Carson
Code-J
https://www.code-j.co.uk/

Share on Facebook Share on Twitter

  Sample input:
FilterOut ( "a¶b¶c¶d¶e¶f" ; "e¶b¶c" )
  Sample output:
"a¶d¶f"

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

This function takes the values of ListB and removes them from ListA. The values in each list can be in any order. This function should work with any version of Filemaker 8.0 onwards. The only limits of list length are driven by the recursion limit.

 

Comments

19752   19752, fmc
Mar 7, 2018
FilterOut ( "abcde" ; "e" ) returns "abc".

You'd need ¶ on both side for partially matching text.
 

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.