Suggest Postal Code (Expression Function)

Purpose

The Suggest Postal Code function (SUGGEST_POSTAL_CODE) takes in a street address, city, and state and returns the postal code that best matches. If one can not be found it will return an empty string.

Parameters

The Suggest Postal Code function has three parameters, all of which are required:

Street

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

The first required parameter is the street part of the address used to find the postal code.

City

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

The second required parameter is the city of the postal code to find

State

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

The third required parameter is the state of the postal code to find

Output

The output of the Suggest Postal Code function is string representing the postal code of the give street address, city, state.

Example

For example SUGGEST_POSTAL_CODE('304 Market St','Harrisburg','PA') will result in “17101” and SUGGEST_POSTAL_CODE('196 Hallam St','Toronto','ON') will result in “M6C1C6”

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