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 <johnpat...@me.com> To: How to use LiveCode <use-livecode@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
