Compare two lists
This tip describes how to compare two lists.
If you need compare two list in Formula or LotusScript, here is solution. @Compare function (in R6) compare only the alphabetic order of the elements in two lists pair-wise.
Formula:
List1 := "A":"B":"C";
List2 := "A":"C":"B";
tmp := @Trim(@Replace(List1;List2;"")) + @Trim(@Replace(List2;list1;"")); @If(tmp = ""; "Equal"; "Not Equal")
LS:
eval = Evaluate(|@Trim(@Replace(List1;List2;"")) + @Trim(@Replace(List2;List1;""))|, doc)
if eval = "" then
print "Equal"
else
print "Not Equal"
end if