Validate City State Postal Code (Expression Function)

Purpose

The Validate City State Postal Code function (VALIDATE_CITY_STATE_POSTAL_CODE) takes in a city, and state and postal code if the postal code is contained in the city and state provided the function will return 1 else it will return 0;

Parameters

The Validate City State Postal Code function has three parameters, all of which are required:

City

Allowed Inputs: City part of a field value or a string

The first required parameter is the city to match to the postal code

State

Allowed Inputs: State part of a field value or a string

The second required parameter is the state to match to the postal code

Postal Code

Allowed Inputs: Postal Code part of a field value or a string

The third required parameter is the postal code to match to the city and state

Output

The output of the Validate City State Postal Code function is 1 for a valid set of values and 0 for an invalid set of values.

Example

For example VALIDATE_CITY_STATE_POSTAL_CODE('Harrisburg','PA',17101) will result in 1 and VALIDATE_CITY_STATE_POSTAL_CODE('Harrisburg','PA',71101) will result in 0

expression function - validate city state postal code.txt · Last modified: 2016/09/14 18:19 (external edit)
Copyright WorkXpress, 2024