>> FoxPro <<
There are a number of ways to skin this cat...
For example "Total on email to NODUPE" is a new one for me... will have
to investigate that command further as it sounds interesting ;-)
in addition to Arnie's steps, some other possibilities.
set unique on
Index on upper(email) to email
The unique will index only the first occurrence of each email set, so,
when the index is set, all dupes will be hidden.
Since email addresses are not necessarily uppercase, the index statement
will take that into consideration...
...then, additional problems arise... seamonkey's address book has two
email fields, so, the dupes may be in different fields.
Add to that that later duplicate entries may have additional or more
valid information, and the potential for data loss arises.
Even having deduped many millions of records during my programming life,
I hate the process since there are so many ways for it to bite back, so,
was glad to discover that someone at google seems to have found a better
way.
Beverly Howard
_______________________________________________
support-seamonkey mailing list
[email protected]
https://lists.mozilla.org/listinfo/support-seamonkey
