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 - Show more from this author
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.

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: