DifferenceValues ( ListA ; ListB )

Returns a single instance of all lines that are in ListA but not in ListB

Average rating: 4.4 (37 votes) Log in to vote

Koen Van Hulle
SHpartners
http://www.shpartners.com

Sample input:

DifferenceValues("Apple¶Pear¶Orange¶Banana"; "Apple¶Orange" )

Sample output:

Pear¶Banana

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

If 
( 
IsEmpty ( ListA & ListB ) 
; 
"" 
; 

Let ( [ 
Item = LeftValues ( ListA; 1 ); 
CountItems = ValueCount(ListA); 
newListA = RightValues(ListA; CountItems-1); 
Valuecheck = FilterValues(ListB; Item); 
Addvalue = If (IsEmpty(Valuecheck) ; Item  ; "") 
] 
; 
Addvalue 
& 
If ( CountItems = 0; "" ; DifferenceValues(newListA; ListB) ) 
) 
)

This function returns a single instance of all lines that are in ListA but not in ListB.
A variant on the XORvalues function from Ray Cologon, NightWing Enterprises

Comments

		PhilFileMaker Sep 2, 2023
A nice function would be to SHOW what values are duplicate If ListA is C_001 C_001 C_002 and ListB is C_001 C_002 We should receive as result C_001

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

DifferenceValues ( ListA ; ListB )

Comments

Support this website.

Support this website.