Splitter is an excellent example of a utility that
does a single task with pizzazz. This Microsoft Access
2003 add-in (there are versions for Access 97, Access
2000 and Access 2002 too) separates names stored in a
single field into separate components -- first name,
middle name, and last name -- making it the perfect
tool for fixing poorly structured tables. The program
handles prefixes, suffixes, and reverse names (such as
Smith, Margaret). It adjusts case and also uses an
editable database of names in order to assign a likely
gender to each name. For example, if you have Mr.
Robert A. Edwards, Esq stored in a single field,
Splitter will separate the name into five new fields
and add another field indicating the name is male. A
wizard steps you through the process and lets you
choose whether to create the new fields within your
current table or in a new table. In either case, your
existing data is untouched. Splitter even assigns a
confidence rating to inform you of how accurate the
split data is likely to be. Can process a million
records in less than fifteen minutes. ZDNet assigned
Splitter 5 out of 5 stars! Contact www.infoplan.com.au

Download (1408 KB) Website Link to this page