Beverly Howard wrote:
>> 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.
That will certainly do the job. I use TOTAL so I know how many
duplicates there were for each address. If you set unique on, you don't
get a count by individual email.
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.
Generally, I don't use the Address book to send emails unless it is just
people in my neighborhood. I maintain a database of about 16,000 for my
high school alums. There is only one record for each alum but there are
cases where husband and wife are both alums and are using the same
email. The same email address will get two emails, one addressed to the
husband and one addressed to the wife.
I use Foxpro to generate a .csv file and then send any message using
Pegasus to create the message and import the .csv file. Because Pegasus
has a merge function, I can create a bunch of variables in the .csv file
and then Pegasus will replace the variable with whatever is in the .csv
file. Especially useful when I'm trying to verify name, address,
telephone, email, etc for each record in the database. Just can't send
more than 400-500 at a time.
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
