Right Fielder Executive Summary...
Helps put your data into the right
fields.
Overview...
Right Fielder is a useful utility to aid the correction of identifying field components from within mixed fields and moving specific data elements to specific field locations. Whilst the software has been written mainly for USA and Canadian data, the software is extremely powerful in helping correct UK and European data.
-
Right Fielder distinguishes between name fields, titles, people names, departments, companies, street addresses, cities, states, zip/post codes, and phone numbers.
-
Examines each field in a record, figures out what you’ve got, and “right fields” the data, moving names into name fields, companies into company fields, etc.
-
Optionally, moves primary addresses into a consistent field for better zip encoding.
-
Reorganises city-state-zip into your preferred format.
-
Recognises foreign addresses and marks them.
-
Canadian version available.
-
Easily customised -- works with Keyword Tables which you control.
-
Lighting fast: processing (approximately 1,000,000 records per hour with a good machine).
-
Works with lists in dBASE and ASCII. Both 16- and 32-bit versions supplied. Windows 3.1 and newer.
-
Front end pre-processor converts “print image” or “label format” files.
-
Simple to use.
Gets the job done with flexibility and ease
Here is a sample record from a “top
justified” file. Notice that SUITE 120 is below the primary address, ONTARIO is
spelled out and the Postal Code is off on its own. To top it all off, some
idiot put ATTN: SUSIE as the last address line!
In the record’s output, RF has moved SUSIE into the Name field and SUITE 120 into the Secondary address line. With Right Fielder you have the option to keep your address lines as entered, put primary above secondary, put secondary above primary, bottom justify, or top justify. It’s all up to you!
Next, Right Fielder went to work on the city/st/zip data. TORONTO and ONTARIO have been parsed and ON given its proper abbreviation.
So in one program, you’ve converted unorganised chaos into accurately fielded data which is far more likely to encode.
Never re-key or reject a Print Image file again!
If your file comes from a word processor, scanned list, or Admark tape, it’s probably what we call a “print image” or “label format”. This example shows RF importing a multi-column file whose records are not aligned horizontally. Without Right Fielder, you have to rekey or reject this file!
Right Fielder’s “Print Image Importer” will automatically determine the file’s structure and convert it into a true .DBF, ready to be “Right Fielded”. It has the flexibility to import several varieties of files, based on how one record is separated from the next: Fixed Size, One or More Blank Lines, or Form Feed.
Right Fielder also works with ASCII flat, fixed, and delimited files. You can choose to: (1) Use the Interactive Importer which automatically determines field structure, (2) Manually enter the file’s structure, (3) Inherit current database’s structure, (4) Append onto current database, or (5) Copy another file’s structure.
For USA addresses, how does it work?
Right Fielder looks up each word in a Keyword Table. Each keyword has up to 5 type indicators or “votes”.
For example, most states are coded “CS” (one vote for Company, one for State). In the Canadian version, “NY” is “CSI”, adding a vote for “International”. “FL” is “CSA” because “FL” might stand for “Floor”. And “LA” is “CSTA” because it might be “Lane” or “La Punta”. Right Fielder tallies all the votes for each field to determine its field type.
