Script for finding duplicate accounts and identifying dups

[dunbarx at aol.com]

Ah, three or more dups.


Of course, the code can test for successive dups, and parse accordingly. But Bernd's array cuts through all that.


Craig



-----Original Message-----
From: Mike Bonner <bonnmike at gmail.com>
To: How to use LiveCode <use-livecode at lists.runrev.com>
Sent: Thu, Nov 19, 2015 3:44 pm
Subject: Re: Script for finding duplicate accounts and identifying dups

I thought about the sort and compare method, and it works well if theresonly 2 that match, more lines of code are needed if there can be multipledupes.  But the single time through sort method is probably faster than thearray method I posted even after tweaking it to allow for multiple dupes.On Thu, Nov 19, 2015 at 1:27 PM, <dunbarx at aol.com> wrote:> Hi.>>> I did not read Bernd's response. Are the records on separate lines?>>> jdoe, 123456> ggarcia, 121212> ggarcia, 131313>>> If they are not. make then so. And then, why not sort the list, and in a> "repeat with..."  loop check each line with the line following. If they> match, extract the two indexes. This should take only six lines of code.>>> Craig Newman>>>> -----Original Message-----> From: JOHN PATTEN <johnpatten at me.com>> To: How to use LiveCode <use-livecode at lists.runrev.com>> Sent: Thu, Nov 19, 2015 3:14 pm> Subject: Script for finding duplicate accounts and identifying dups>> Hi All,I have a list of user accounts and unique IDs. The user accounts> are first initial + last name. A typical list might look like the> following:jdoe, 123456ggarcia, 121212ggarcia, 131313I’m trying identify the> duplicates, list the username and their unique 6 digit id.I have been using> the following code that Bernd shared while ago:> http://forums.livecode.com/viewtopic.php?f=9&t=6226#p28787 <> http://forums.livecode.com/viewtopic.php?f=9&t=6226#p28787>…but it only> works if i leave off my unique 6 digit IDs from my list of accounts,> naturally.  I would like to be able to identify the user accounts that are> exact duplicates but then differentiate them by their unique 6 digit ID. So> essentially, create a new list of just the duplicates and ids, i.e.ggarcia,> 121212ggarcia, 131313Thanks in advance for any ideas!John> PattenSUSD_______________________________________________use-livecode> mailing listuse-livecode at lists.runrev.comPlease visit this url to> subscribe, unsubscribe and manage your subscription preferences:> http://lists.runrev.com/mailman/listinfo/use-livecode> _______________________________________________> use-livecode mailing list> use-livecode at lists.runrev.com> Please visit this url to subscribe, unsubscribe and manage your> subscription preferences:> http://lists.runrev.com/mailman/listinfo/use-livecode>_______________________________________________use-livecode mailing listuse-livecode at lists.runrev.comPlease visit this url to subscribe, unsubscribe and manage your subscription preferences:http://lists.runrev.com/mailman/listinfo/use-livecode