Need help comparing 2 lists with Formula Lang

HCL Domino Domino Forum
1

For a couple reasons, in this one particular button, I have to use formula, not LotusScript.

What I am trying to do is compare two lists, and return only the values that exist in ListA but are not in ListB. I tried concatenating the lists and using @Unique, but that didn’t work since @Unique still returns the first occurence of the value if it is in both lists, and I need any duplicate value to be gone completely. Any ideas?

Thanks

2

Subject: Need help comparing 2 lists with Formula Lang

Try @Trim(@Replace(ListA; ListB; “”)). @Replace will replace any occurance of an item in list A matching any item in list B with an empty string. @Trim removes those values from the list.