Compare two lists

• Lubomir Veselovsky
• Published: 31 Oct 2002

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