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

This was first published in October 2002

Dig deeper on Domino Resources - Part 3

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchWinIT

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchEnterpriseLinux

SearchVirtualDataCentre.co.UK

Close