I wrote a routine called “ListIntersect”, which I’ve posted on GitHub.
We originally wrote it in Omnis Studio 3, but it’s up on GitHub in
Studio 8 format.
Basically you use it like this:
* plList1 – the larger of the two lists to process. It can have
duplicate values in the column that you’re testing
* plList2 – the smaller of the two lists.
* psFieldname – the column name in the list that you’re comparing again
* psFieldtype – options are Char, Int, Num or Date.
OUT: All lines in list1 that exist in list2 will be selected in list1.
Both lists will be sorted by the nominated field name.
The comparison column must be the same name/type in both lists.
You can download the code here:
> Message: 19
> Date: Sat, 3 Feb 2018 14:27:26 +0100
> From: Bo Carle? <email@example.com>
> To: OmnisDev List – English <firstname.lastname@example.org>
> Subject: List problem
> Message-ID: <etPan.email@example.com>
> Content-Type: text/plain; charset=”utf-8″
> I have 2 lists. List 1 with 1226 lines. List 2 with 9663 lines.
> All lines from list 1 are also included in list 2.
> What I want to do is to clear list 2 from all list 1 lines.
> Anyone who has a solution for this task?
(sent from the webmail of)
Paul W. Mulroney Logical Developments
firstname.lastname@example.org 86 Coolgardie Street
www.logicaldevelopments.com.au BENTLEY WA 6102
Ph: +61 8 9458 3889 Fax: +61 8 9458 2169