ACC: Sample Expressions to Extract Portion of Text String

This article lists sample expressions that you can use to extract a portion of a text string. These expressions are commonly used in the Update To line of an update query to place a portion of a larger field into a new field. You can adapt these expressions for use with other common formats. For example, the expression you would use to extract "Doe" from "Doe, John" you can also use to extract "Seattle" from "Seattle, WA."

The following expressions are sample expressions that you can use to extract a portion of a text string.

NOTE: In the following sample expressions, an underscore (_) at the end of a line is used as a line-continuation character. Remove the underscore from the end of the line when re-creating the expression.

First Name

First Name

First Name

Last Name

Last Name

Last Name

Last Name

Middle Initial

Middle Initial

Zip Code

Area Code

Phone Number

For more sample expressions, see the Neatcode.mdb sample databases. For details on how to obtain these databases, please see the following articles in the Microsoft Knowledge Base: