[dba-VB] NetGender - The Software Company

I purchased a .Net library that does name splitting.

http://www.softwarecompany.com/dotnet/netgender.htm

It seems to work well just from using the little demo that you can 
download.  Now I am starting to actually work with it.  It consists of a 
single class, embedded in a dll that you reference, with properties to 
set to tell it all of the controlling stuff, then properties to hand it 
the name to split and read back the name pieces.

The developer claims that it will handle between 2K and 3K names per 
second.  We shall see.

So here I am trying to work with this thing.  The demo form is quite 
extensive and shows how to read / write all of the properties to 
populate the form.

I have a database with (of course) about 80 million names, in a single 
field, in the form LastName FirstName MiddleInitial (no commas etc) 
which needs parsing.  What I thought I would do (just for the moment) is 
to use the existing form and just feed in the names.  Thus I need to add 
a couple of properties to the form such that I can feed in names and get 
back the parsed pieces.  I will build a switch to tell the form to 
display the pieces or not, thus I could watch the process function if I 
wanted, though at the cost of slowing the process down.

-- 
John W. Colby
www.ColbyConsulting.com