AO Multi Line Name Parse

Line 1...8

One or more fields containing Name data.

• Default: none

Name order field

Optional field indicating whether names are formatted with first name first or last name first. This is a two-byte text field containing the values FL (first name followed by last name) or LF (last name followed by first name). If this is unspecified, names are assumed to be first name followed by last name.

• Default: none

Max output name fields

Specify the number (1-16) of name fields that can be output.

• Default: 2 per input line

Suppress descriptors

Select if you do not want descriptors to be appended to the output records.

• Default: yes

Field name as descriptor

Select to append field names to output records as descriptors. This indicates which field a name was found in.

• Default: no

Line 1...8 descriptor

You can optionally specify fields to associate descriptive data with output fields. You must clear the Suppress descriptors option.

• Default: yes

Use large table

Select to use Data Management's comprehensive parsing lookup table. If you are resource-limited, you should leave this off.

• Default: no

Treat "/" as AND

If the name field might contain two names separated by a slash ("/"), select this option to ensure that the name is parsed correctly.

• Default: no

Fix reversed First/Last

Select this if you suspect that your records may have First name and Last name reversed.

• Default: no

Preserve dual LastName

If the name field might contain names with two last names, you can select this option to put both in a single last name field. If you have the name Mary Andrews Smith, selecting this option will write Andrews Smith to the OUT_LNAME1 field. If this option isn't selected, Andrews will be written to the OUT_MIDNAME1 field and Smith will be written to the OUT_LNAME1 field.

• Default: no

Split hyphenated LastNames

If the name field might contain names with hyphenated last names, you can you can select this option to store hyphenated last names in separate fields. If you have a last name of Watson-Jones, selecting this option will write Watson to the OUT_LNAME1 field and Jones to the OUT_LNAME1_2 field. If this option isn't selected, then Watson-Jones will be written to the OUT_LNAME1 field.

• Default: no

Parse suffix types

Select this option to distinguish between generational suffixes such as Jr and III, suffixes such as DR and PhD and professional titles such as Finance Manager. An input name of the form "James Smith III, MD" will be output with "III" in the OUT_POSTNAME1 field and "MD" in the OUT_SUFFIX1 field. The name "Janice Jones, PhD, VP of Development" will be output with "PhD" in the OUT_SUFFIX1 field and "VP of Development" in the OUT_PROFTITLE1 field. Without this option checked, "PhD" and "VP of Development" would both go to the OUT_SUFFIX1 field.

• Default: yes

No punctuation in titles

Select to remove the punctuation from honorary titles. This will strip the periods in titles like M.D.

• Default: no

Capitalization

Choose capitalization style of the output.

• Default: original

Treat "President" as

You can treat the word "President" as either Title or Prefix. If you select Title, then "President" will be put in the OUT_PROFTITLE1 field.

• Default: title

Treat "C O" as "C/O"

Select to interpret the string "C O" as "Care Of".

• Default: yes

Add prefix if none present

Select to add a prefix such as "Mr" or "Mrs" to names that don't have one. Use the other prefix options (below) to specify the default prefix.

• Default: no

Default male prefix

Select a default male prefix from the list.

• Default: MR

Default female prefix

Select a default female prefix from the list.

• Default: MS

If multi-name use alt female prefix

Select to assign a prefix to the female name if a pair of parsed names includes a female.

• Default: yes

Alt female prefix

If you selected If multi-name use alt female prefix, select a default female prefix.

• Default: MRS