The information that is typed into the address label is separated into three areas. The first line is considered the name line and is parsed into the Prefix, First, Middle, Last, Suffix, and Appellation fields. The last line is considered the City, State, and ZIP Code information and is parsed into those fields. The remaining lines are parsed into the address lines.
The name line is first checked against the prefix code file. If there's a match, the prefix code translation is entered in the Prefix field. The name line is then checked for the occurrence of the word and or the symbol & in the second-to-last position on the name line. If it finds either followed by Family, Friends, or Company, the string is saved as an appellation. If none of these three words follow the and or &, the string is checked for a valid suffix. The name line is next checked for commas, and if one is found, the word to the right of the comma is checked against the Suffix code file. If a match is found, it places the word in the Suffix field; if a match is not found, it places the word in the Appellation field. The remaining name line words are checked and parsed as follows: the last word is placed in the Last field, the first word in the First field, and any words between in the Middle field.
To enter a two-word first or last name, type an underscore character between the words when you type them in the label field. For example, if you type the name Mary_Beth Mac_Taggart, both words of the first name are entered in the First field, and both words of the last name are entered in the Last field. The underscore character is replaced with a space in those fields.
IQ follows certain rules for separating the components of an address into People fields. The components are assigned to data fields according to the number of lines in the block, as the table shows.
|
No. of Lines |
Field Assignment |
|
1 |
Name |
|
|
|
|
|
|
|
|
2 |
Name |
CSZ |
|
|
|
|
|
|
|
3 |
Name |
Addr Line1 |
CSZ |
|
|
|
|
|
|
4 |
Name |
Addr Line1 |
Addr Line2 |
CSZ |
|
|
|
|
|
5 |
Name |
Org1 |
Addr Line2 |
Addr Line2 |
CSZ |
|
|
|
|
6 |
Name |
Title |
Org1 |
Addr Line1 |
Addr Line2 |
CSZ |
|
|
|
7 |
Name |
Title |
Org1 |
Org2 |
Addr Line1 |
Addr Line2 |
CSZ |
|
There will be times when the address you're entering does not match this breakdown, for example if you're entering an address with a title, an organization, and only one address line. In that case you must identify the address components with some of the following prefixes:
n: or n; for name
t: or t; for title
o: or o; for organization
a: or a; for address line
z: or z; for city, state and ZIP Code
f: or f; for foreign country
It is unnecessary to prefix every line. Most of the time you should only need to prefix the first address line and maybe the first organization line to insure accurate parsing, as in the following example:
Mr. John Smith
President
o:Smith Enterprises
1005 Main Street
22381
Case normalization is applied to the name by uppercasing the first initial of each word. If you're using Address Checker, case normalization is applied to words in the address, city, and state fields. You must use proper casing when typing the title and organization information.
Anything found to the left of the comma in the last line of the address block is placed in the City field. The remaining words are placed in the State, ZIP Code, and ZIP Code extension fields as appropriate.