Troubleshooting help

[lcurrie]

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

[mr_vodka]

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

Edited October 30, 2006 by Guest

[lcurrie]

Thanks for the confidence boost.

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

Lynn

[John Mark Osborne]

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