FilterOut ( ListA ; ListB )

Filter the values of Lists out of ListA

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

Jul Carson - Show more from this author
Code-J
https://www.code-j.co.uk/

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)

/*
Removes values in ListB from ListA.

Example:		FilterOut ( "a¶b¶c¶d¶e" ; "e¶b¶c" ) returns "a¶d"

Created:		22.02.18 Jul Carson   Code-J UK
			mail.codej@gmail.com   www.code-j.co.uk

Rights:		Free to use. Please credit the author
*/

If ( IsEmpty ( ListB ) ; 
	ListA ; 
	Let ( [ 	~item  =  GetValue ( ListB ; 1 ) ; 
			~newA = Substitute ( ListA & ¶ ; ~item & ¶ ; "" ) ; 
			~newB = Substitute ( ListB & ¶ ; ~item & ¶ ; "" ) 
		] ; 
		FilterOut ( Left ( ~newA ; Length ( ~newA ) - 1 ) ; Left ( ~newB ; Length ( ~newB ) - 1 ) ) 
	) 
)

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, fmc Mar 7, 2018
FilterOut ( "abcde" ; "e" ) returns "abc". You'd need Â¶ on both side for partially matching text.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

FilterOut ( ListA ; ListB )

Comments

Support this website.

Support this website.