1. RightFielder Content
    1.1 Right Fielder Basics

1.1.1 What is the RightFielder API and how will it improve my
        data quality?
1.1.2 Should I process every field in my database, and output
        every possible data type the API allows?
1.1.3 What programming environment can call the RightFielder
        API?
1.1.4 Is there any example code?
1.1.5 If one of my input fields contains Fullnames, will it re-field
        them into separate FIRST and LAST name fields?
1.1.6 How does RightFielder differentiate a fields contents
        between different Data types?
1.1.7 Do I have any control over how RightFielder processes my
        file?
1.1.8 Will RightFielder re-field an Address and a City State Zip
        all in one input field into separate output fields?
1.1.9 What data types does RF recognize?
1.1.10 Will it re-field International data?

1.1.1 What is the RightFielder API and how will it improve
          my data quality?
The Right Fielder APITM is a programming library used to reorganize data so that each field contains the correct kind of contact information.

Typical uses for this library are: Real-time data entry re-fielding. When users fill out web forms incorrectly, RightFielder can, for example, identify that a second address line was accidentally typed into the CityStateZip field. Data Storage. Now that RightFielder has identified the wrong datatype, you can store it in the correct field of your database preventing costly waste when trying to verify addresses, presort your mailing list, or running queries to retrieve records for a particular zip code – which could have been stored incorrectly in another field. RightFielder should also be used to clean up existing databases where data entry or appending records has made field data storage inconsistent.

1.1.2 Should I process every field in my database, and
          output every possible data type the API allows?
No, the API will only allow you to process 10 input fields at a time. Since Right Fielder is evaluating all recognizable key words in each input field for each record, and trying to determine how to output them, processing only the input fields which need to be corrected and creating the proper number of outputs will greatly increase the accuracy. In other words, if only names, companies and addresses are comingled in the first three fields, only process those three fields and don’t create an output phone or country field.

1.1.3 What programming environment can call the
          RightFielder API?
The library is provided as a 32-bit Windows DLL, and will work with any 32-bit Windows operating system (Windows 95/98/98se/Me, Windows NT, Windows 2000, Windows XP).

1.1.4 Is there any example code?
The demo comes with example projects for many popular programming languages like, C++, FoxPro, Visual Basic, and SQL Server. While limited in practical usage, these examples show all steps needed from Initializing the API to returning the Output results.

1.1.5 If one of my input fields contains Fullnames, will it           re-field them into separate FIRST and LAST name           fields?

No, If field data contains a first name or a fullname, it will be recognized as a name data type, but will not split out the last names. We have another program, Personator which splits fullnames into parsed first and last name fields.

1.1.6 How does RightFielder differentiate a fields contents           between different Data types?

RightFielder uses programmed logic and Lookup tables to intelligently distinguish what each word is, compared to the other words in the field as well as neighboring data in the previous and next fields.

1.1.7 Do I have any control over how RightFielder           processes my file?

Absolutely! Recognized key words are maintained in the accompanying Lookup tables, which you can modify how each keyword is coded, add new entries, or delete existing ones.

1.1.8 Will RightFielder re-field an Address and a City State           Zip all in one input field into separate output fields?

No. If that field is consistently delimited, whether by a delimiter such as a ‘:’, or by field position, you may use Personator to split the fields’ contents. If you can’t identify anything that will always split the contents correctly, you’re out of luck.

1.1.9 What data types does RF recognize?

RightFielder will identify Names, Addresses, Departments, Companies, Addresses, Cities, States and Provinces, Zip and Postal codes, Phone numbers, and Countries.

1.1.10 Will it re-field International data?

While RightFielder does an excellent job with domestic US and Canadian data, recognizing the data types of other countries is beyond the scope of this program. It will however, flag Countries if the name of the Country is in one of the input fields, most accurately if that name is the last non-numeric word in the last input field. This is not to say that if you have a compiled list of international key words of the data types we process, and what they represent, you can’t make RightFielder work. You are welcome to massively edit the lookup tables and give it a shot; we just don’t have the international expertise to guarantee the results.