3 lists comparison

Posted on 2006-06-17
Last Modified: 2013-12-18
Hi all,

Is there anyway that I can compare three lists in the one formula.
I know that I can use the @replace to compare two lists, but not sure if I can compare three lists.

For example, I want to find out those items which are in the first list and the second list but not in the third list

list1: item1, item2, item3
list2: item1, item4, item 5
list3: item6, item7, item8

Myresultlist should contain: item1
Is this possible?

Any ideas, help is much appreciated

Question by:varvoura
  • 2
  • 2
  • 2
LVL 43

Assisted Solution

by:Steve Knight
Steve Knight earned 100 total points
ID: 16928563
Combine List1 and list2 with @Unique(List1:List2) then use the same formulas as before.

LVL 43

Expert Comment

by:Steve Knight
ID: 16928573
And reading again ... I'm clearly talking rubbish.  A two stage check of list1 with 2 then the result with 3 should work, haven't got Notes at the moment to try it and off now anyway, no doubt someone else will be along shortly :-)


Author Comment

ID: 16928630
two stage check??
Are you saying the @replace twice? with list1, list2 and then the resulted field with list3?

I'll attempt anyway, but I'd need further clarification to this.


Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

LVL 46

Accepted Solution

Sjef Bosman earned 150 total points
ID: 16929733
@Trim(@Replace(@Trim(@Replace(list1; @Trim(@Replace(list1; list2; "")); "")); list3; ""))

Author Comment

ID: 16930740
thanks sjef, I'll try that today but somehow I know it will work fine with no problems.

Thanks for your help
LVL 46

Expert Comment

by:Sjef Bosman
ID: 16932511
Trying won't offend me, since I never tested it. What's more important, assuming it works: try to unravel it, why does it work?

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This is an old article, please see an updated version of this article, located here:
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question