[AccessD] Need names

Great idea.

Thanks

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Henry Simpson
Sent: Friday, February 21, 2003 10:39 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Need names


If you have 10000 names already, assuming first name and last name fields,
set up a loop that concatenates first name of current record plus move n for
last name, then move back n-1 and increment n in the loop until it reaches
EOF.  Start the next loop from record n + 1.  This will generate 9999 + 9998
+ 9997 ... name records without even getting into middle names or initials.
You can then let the dupes wizard find the dupes and nuke them.  If you let
n go from 1 to about 105, you'll have near enough a million names.  Let it
go the full 10000 and you get 50,000,000 before culling duplicates.

Whenever I create a demo database that requires a significant number of
Employee or Contact records, I take a few thousand real names and mix and
match them up in this manner.  If phone numbers are required, a random
number works OK but I often use something like an address ordered company
table list of fax numbers so as to get real area codes and sensible numbers.

Hen




>From: "John W. Colby" <jcolby at colbyconsulting.com>
>Reply-To: accessd at databaseadvisors.com
>To: "AccessD" <AccessD at databaseadvisors.com>
>Subject: [AccessD] Need names
>Date: Fri, 21 Feb 2003 19:50:38 -0500
>
>Can anyone send me a db with just the first name / last name of a BUNCH of
>people (hundreds of thousands)?  I have built a hash algorithm that returns
>no duplicate values for 10,000+ names (assuming no duplicate names).  I
>would like to test it for hundreds of thousands of names.  I will worry
>about getting rid of dupe names.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com