- Introduction to WorkXpress
- Building Your Application
- Examples and Best Practices
- Technical Manual
This shows you the differences between two versions of the page.
expression function - suggest zip code [2016/09/14 18:19] |
expression function - suggest zip code [2016/09/14 18:19] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== 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. | ||
+ | |||
+ | {{:suggest_zip_code_initial.png?direct&600|}} | ||
+ | |||
+ | ===== Parameters ===== | ||
+ | The **Suggest Postal Code** function has three parameters, all of which are required: | ||
+ | |||
+ | ==== Street ==== | ||
+ | |||
+ | Allowed Inputs: Street part of a [[Field|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|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|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" |