Exceptions Table Input - Finalist

Exceptions Table Input - Finalist - 10.0

Finalist Guide

Product type

Software

Portfolio

Verify

Product family

Data Quality - Postals

Product

Finalist

Version

10.0

Language

English

Product name

Finalist

Title

Finalist Guide

2023

First publish date

1984

Last updated

2024-05-15

Published on

2024-05-15T00:57:22.811031

To use an exceptions table, you can use any text editor to create a file in a text format. Record lines must be no more than 80 characters in length. The following table describes the fields available for an exceptions table entry. All field positions need to be specified exactly as shown.

Table 1. Exceptions Table Entry Fields and Positions
Field Name	Position	Description
L#	1-2	This required field designates the address line that the entry affects. Possible values for L# are described next. L1 = First address line L2 = Second address line L3 = City/state line
ARGU	3 - 17	This required field contains a one-word argument (keyword) or the first word of a two-word argument for which you want Finalist to search.
SUBST A	18 - 32	This required field contains the word that replaces, or is used with, ARGU. For an IG-type entry, leave this field blank. Blanks are only valid with an IG-type entry. For a ++-type entry, this field becomes the second word of a two-word argument.
ATTRIBUTE	33 - 34	This required field contains the two-digit code to supply more information about the substitute word or the change being made on the argument word.
ZIP  Region (first digit of ZIP Code)  SCF (first 3 digits of ZIP Code)  ZIP Code	35  35 - 37  35 - 39	This optional field specifies the region, SCF, or ZIP Code for which the exception logic works. If this field is blank, exception logic works for all input data.
SUBST B	40 - 54	This optional field contains the replacement for ARGU and SUBST A in a ++-type exceptions table entry. This optional field is also used in the R+ operation, which concatenates SUBST B with SUBST A as a replacement for ARGU.

The following table provides a list of available attributes for each address line.

Table 2. Attributes for Address Lines
Address Line(s)	Attribute	Description
L1 and L2	DR	Replace argument word with substitute word. The substitute word is a directional.
	I2	Insert the substitute word as a unit designator before the target word.
	ID	Insert the substitute word as a directional before the argument word.
	IN	Insert the substitute word after the argument and make it part of the street name.
	IP	Insert the substitute word as a directional after the argument word.
	IS	Insert the substitute word as a suffix after the argument word.
	IU	Insert the substitute word as a unit designator after the target word.
	SF	Replace argument word with substitute word. The substitute word is a suffix.
	UD	Replace argument word with the substitute word. The substitute word is a unit designator.
	RR	Replace argument word with the substitute word. The substitute word is a Rural Route (RR) word.
L3	IC	Insert the substitute word as a city before the argument state abbreviation.
	ST	Insert the substitute word as the state abbreviation after the argument city word.
L1, L2, and L3	++	Combine the argument and substitute words to make one word.
	CT	Attach (concatenate) the substitute word to the following word in the input record.
	IG	Ignore the argument word.
	R+	Replace argument word with the concatenation of substitute word A and substitute word B.
	RP	Replace argument word with substitute word.