Hi All,

I'm working on a delete duplicates script based on some posts i've found on the forums. Obviously, i'm missing something.

}:|

I've posted the script I've created here.

When i run the script, i can tell the find all part works, but then, very quickly (way too quickly for it to be checking duplicates - like a second or two) the script ends up at the last record.

Here is the basic premise/thinking:

GLOBAL is a global storage container.

- find all records

- sort them by email address

- set global to a calculation of 'email address with name'

- compare GLOBAL to actual 'email address with name'

- if = delete record

- if not, set new GLOBAL and repeat until the last record.

Thanks for any help you can provide.

Thanks!

Lynn

Lynn are you certain it is not working? The script should be working.

Edited October 30, 200619 yr by Guest

Thanks for the confidence boost.

I ran it again comparing only email addresses (not names) and, you're right, it works!

Lynn

I typed this script into an example file and it appears to work but actually deletes the last set of duplicates without keeping one. I rewrote the script and it seems to be working (let me know). See the attached file.

However, I am not sure why your script is running so quickly and not deleting the duplicates. Is it possible your global field wasn't actually defined as a global field?

dups.fp7.zip