<< Click to Display Table of Contents >> Navigation:  Available Functions > AddressExpand()

Syntax

AddressExpand( <cAddressToExpand>, <lIgnoreCase> )

 

Purpose

To expand abbreviations in addresses to full spellings, and remove periods.

 

Parameters

<cAddressToExpand> is the name of a character field in DonorQuest containing the address you wish to expand. It may also be the name of an address field within an external file which you are importing into DonorQuest.

 

<lIgnoreCase> is a true/false value. If true, case will be ignored during address expansion. This will result in abbreviations such as blvd, Blvd, and BLVD will be considered to be the same and will be expanded to Boulevard. If this parameter is true, then the resulting expanded address will also be in all upper case. If this is not desired, yet you wish to ignore case, then you could apply the CaseNormalize() function to the result in a call like this: CaseNormalize( AddressExpand( .Address. ) )

 

Returns

The given address, with all abbreviations translated to their full spellings.

 

Usage

AddressExpand() is normally used when importing data to insure imported addresses adhere to the standard for addresses you wish to use in your donor database. It may also be used to mass update existing records in your database using the Replace feature of Selection Results. Used in conjunction with the AddressAbbreviate() function, you may format address data to adhere to one of three standards: No Abbreviations, Abbreviations, and Abbreviations with periods. The No Abbreviations standardization would expand all addresses to have the full spellings of street suffixes and directionals, resulting in addresses such as, "1234 First Avenue Northeast." Abbreviations would result in addresses such as, "1234 1st Ave NE", and Abbreviations with periods would result in addresses such as, "1234 1st. Ave. N.E."

 

The AddressExpand() function also knows common abbreviation misspellings, so it may be used to clean up an already abbreviated list of addresses. For example, replacing all existing addresses with AddressAbbreviate( AddressExpand( .Address. ) ) would first expand an address to full spellings, including expanding incorrect abbreviations to the intended full names, then it would deliver the entire address properly abbreviated.

 

Example

The following examples illustrate AddressExpand():