Script for finding duplicate accounts and identifying dups

[Bob Sneidar]

I'm wondering why not use filter? For each line, in the list, copy the list to a temp variable

put tList into tTemp
put item 1 of line tCurrentLine into tKey
filter tTemp with tKey & "*"

then check for duplicates:

if the number of lines of tTemp > 1 then put tTemp & cr after tDuplicates

If the list is really large however, this may not be the most efficient way.

Bob S


On Nov 19, 2015, at 12:12 , JOHN PATTEN <johnpatten at me.com<mailto:johnpatten at me.com>> wrote:

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, 123456
ggarcia, 121212
ggarcia, 131313