Re: Compare two lists

2013-09-02 Thread John Allijn
Thanks Geoff, Much appreciated! On 3-9-2013 1:16, Geoff Canyon wrote: This is the answer I was about to propose. On Mon, Sep 2, 2013 at 5:58 AM, Monte Goulding wrote: On 02/09/2013, at 8:57 PM, Monte Goulding wrote: item 1 of tLine,item 2 of tLine,item 3 of tLine oops... obviously I mea

Re: Compare two lists

2013-09-02 Thread Geoff Canyon
This is the answer I was about to propose. On Mon, Sep 2, 2013 at 5:58 AM, Monte Goulding wrote: > > On 02/09/2013, at 8:57 PM, Monte Goulding > wrote: > > > item 1 of tLine,item 2 of tLine,item 3 of tLine > > oops... obviously I meant item 1 to 3 of tLine... > > -- > Monte Goulding > > M E R G

Re: Compare two lists

2013-09-02 Thread dunbarx
I agree with Monte about using arrays. I tried this: on mouseUp get fld "oldList" repeat with y = 1 to the number of lines of it put item 1 of line y of it into tList["oldList"][y]["country"] put item 2 of line y of it into tList["oldList"][y]["city"] put item 3 of line

Re: Compare two lists

2013-09-02 Thread John Allijn
Hi Alex, Monte, Thank you for your fast answers and great approaches. I've been struggling with this for a few weeks now! thanks, John. On 2-9-2013 12:58, Monte Goulding wrote: On 02/09/2013, at 8:57 PM, Monte Goulding wrote: item 1 of tLine,item 2 of tLine,item 3 of tLine oops... obviously

Re: Compare two lists

2013-09-02 Thread Monte Goulding
On 02/09/2013, at 8:57 PM, Monte Goulding wrote: > item 1 of tLine,item 2 of tLine,item 3 of tLine oops... obviously I meant item 1 to 3 of tLine... -- Monte Goulding M E R Goulding - software development services mergExt - There's an external for that! __

Re: Compare two lists

2013-09-02 Thread Monte Goulding
I would parse both fields into the same array like this: repeat for each line tLine in field "lastWeek" put item 4 of tLine into tArray[item 1 of tLine,item 2 of tLine,item 3 of tLine]["lastWeek"] end repeat repeat for each line tLine in field "thisWeek" put item 4 of tLine into tArray[ite

Re: Compare two lists

2013-09-02 Thread Alex Tweedly
John, How about something like (rough, untested pseudo-code) put 1 into tLast put 1 into tThis put the number of lines in pLastWeek into countLast put the number of lines in pThisWeek into countThis repeat until the sun goes down (I don't like to do "repeat forever ...") if tLast > co

Compare two lists

2013-09-02 Thread John Allijn
An automated system sends me weekly reports with the following structure:  Country,city,device_type,numer_of_devices I'm working on an app that evaluates these reports and there is one thing I can't get done.  I'd like to compare this weeks report with that of last week and report changes.  Outpu