DifferenceValues ( newList ; compareList )

Difference of values not found in the compare list.

Be the first to rate this function Log in to vote

Rob Poelking - Show more from this author
Kiza Solutions
https://kizasolutions.com

Sample input:

DifferenceValues ( List ( "A" ; "G" ; "F" ) ; list ( "A" ; "B" ; "C" ) )

Sample output:

G
F

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

/**
 * ==================================================================
 * DifferenceValues ( newList ; compareList )
 *
 * PARAMETERS:
 *		@newlist (text) return separated list of new values
 *		@compareList (text) return separated list of values which are 
		already existing. Can be null.
 * RETURNS:
 *		(text) return separated list of values of items found in newList
 *		that are not found in the compare list
 * DEPENDENCIES:
 *		FileMaker 19 minimum version
 * PURPOSE:
 *		Compares 2 list and returns the values found in newList that are
 *		not found in the compare list. 
 * NOTES:
 *		none
 * REVISIONS:
 *		Rob Poelking 1/13/21 - intial version v1
 * ==================================================================
 *
 */

While ( 
	
	[
	/*testvalues*/
		//newList = List ( "A"; "G" ; "F" ) ;
		//compareList = List ( "A" ; "B" ; "C");
	/*end test values*/
		~count = ValueCount ( newList ); 
		result = Null;
		~i = 0 
	 ] ; 
		~i<~count ; 
	[ 
		~i=~i+1;
		value = GetValue ( newList ; ~i ) ;
		exists = ValueCount (FilterValues (value;compareList));
		result = If (not exists ; List ( result ; value))
		 
	] ; 
		result 
	)

This function will render a return separated list of values that are in the newList but not found in the comparisonList. This is helpful, for example, to take a list of already selected items and still present them in a new picker list, allowing the user to make new selections.

Comments

		Andrew Oct 16, 2022
Null is generating an error - parameter not found. I'm no expert but I will try replacing Null with 0

		Rob Poelking, Kiza Solutions Oct 17, 2022
My bad. Null is another CF. Replace with with empty quotes (""). I will update the function now so there is no dependency.

		Rob Poelking, Kiza Solutions Oct 17, 2022
Actually, using 0 in this case is fine.

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

DifferenceValues ( newList ; compareList )

Comments

Support this website.

Support this website.