List problem
Hi Bo,
There is also a method $removeduplicates that you can use on the search column.
Best,
Andreas
> Am 04.02.2018 um 11:04 schrieb Bo Carleö <bo@corbisoft.com>:
>
> Thanks Paul
>
> Problem is solved but I will certainly look into your code.
> Might learn something.
>
> Regards
> Bo
>
> På 4 februari 2018 kl. 04:50:51, Paul Mulroney (pmulroney@logicaldevelopments.com.au) skrev:
>
> Hi Bo,
>
> 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:
>
> Do voListInterection.$ListIntersect(plList1,plList2,psFieldname,psFieldtype)
>
> IN:
> * 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.
>
> NOTE
> 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:
>
> github.com/pmulroney/ListIntersect_for_Studio5
>
> Regards,
> Paul.
>
>
>> Message: 19
>> Date: Sat, 3 Feb 2018 14:27:26 +0100
>> From: Bo Carle? <bo@corbisoft.com>
>> To: OmnisDev List – English <omnisdev-en@lists.omnis-dev.com>
>> Subject: List problem
>> Message-ID: <etPan.5a75b8be.30116908.3a7@corbisoft.com>
>> Content-Type: text/plain; charset=”utf-8″
>>
>> Hi
>>
>> 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?
>>
>> TIA
>> Bo
>
> —
> (sent from the webmail of)
> Paul W. Mulroney Logical Developments
> pmulroney@logicaldevelopments.com.au 86 Coolgardie Street
> www.logicaldevelopments.com.au BENTLEY WA 6102
> Ph: +61 8 9458 3889 Fax: +61 8 9458 2169
>
>
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com