- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
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.
The Suggest Postal Code function has three parameters, all of which are required:
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.
Allowed Inputs: City part of a field value or a string
The second required parameter is the city of the postal code to find
Allowed Inputs: State part of a field value or a string
The third required parameter is the state of the postal code to find
The output of the Suggest Postal Code function is string representing the postal code of the give street address, city, state.
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”