Domino Code Fragment

Code Name*
List Comparison
Date*
04/28/2024
Source (or email address if you prefer)*
Rlatulippe@romac.com
IP address:.18.118.120.109
Description*
Compare two list and return only the values not found in both list.
Type*
Formula
Categories*
(Misc)
Implementation:
Required Client:
Server:
Limitations:
Comments:
Files/Graphics attachments (if applicable): Code:
Okay it took me a little thought but it works.
First I made three fields Test, Test_1 and Test_2
Test was my first list of elements
Test_1 was my second list of elements
Test_2 was my computed list.
With that in mind the following works. I had to uppercase
because @Keywords does case sensitive.


SetA :=  @Unique(@Uppercase( test : test_1));
SetB := @Keywords(@Uppercase(Test) ; @Uppercase(Test_1));
REM "Create a text list of nulls equal in number to SetA";
NullList := @Explode(@Repeat(";"; @Elements(SetA)); ";");
REM "Replace SetA members that match members in setB with nulls";
NewList := @Replace(SetA; SetB; NullList);
REM "Remove the null entries";
@Trim(@Propercase(NewList))