Splitter is an excellent example of a utility that does a single task with pizzazz. This Microsoft Access 2002 add-in (there are versions for Access 97 and Access 2000 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
|