You can use the AddrScan function to:
- Identify individual components within a multiple-line address record
- Format and standardize the address information using USPS logic
- Return the processed address lines in an order you specify
- Identify firm, street, and city lines, so you can use the best combination of data from unstructured lists or multi-use lists to reformat and restructure your address files
- Preprocess addresses that contain multiple lines or "floating" lines
A floating line is an address line or city/state/ZIP Code line whose position appears in different parts of an address record. This line moves, or "floats", to any of the fixed number of fields allocated to a name/address record. The following example illustrates the concept of floating address lines.
Example
In the first example address, the PO box is located on the first line. In the second example address, the PO box is located on the second line. The position of the PO box data moves or "floats" in the address record.
PO Box 99813
654 S Lawndale
Roseville, MI 48066
654 S Lawrence Ave
PO Box 9981B
Roseville, MI 48066AddrScan lets you concatenate multiple address lines and return two address lines, a city/state line, a firm line, and a 10-byte ZIP + 4 field from the floating address lines. By returning fixed lines for processing, you eliminate the need to search for address, city/state, and ZIP Code components.
AddrScan attempts to preprocess addresses that contain multiple or floating lines. AddrScan cannot extract address information in the middle of other information on the same line. AddrScan may not be able to process address information spread across non-contiguous lines. The following is an example of address data that cannot be processed clearly.
Example
2200 Western Ct
Ed's Place IS Apt 100
Account In Question 12345
Lisle IL 60532
3618