Splitter for Microsoft Access
v4.2.1Splitter is a Microsoft Access add-in designed to separate names stored in one field into two or more fields. If both first and last names are stored in the same field and are separated by a space, Sp...
Description
Splitter is an excellent example of a utility that does a single task with pizzazz. This Microsoft Access 2007 add-in (there are versions for earlier versions of Access 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
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
