Differences

This shows you the differences between two versions of the page.

Link to this comparison view

expression function - suggest postal code [2016/09/14 14: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"​
expression function - suggest postal code.txt ยท Last modified: 2016/09/14 14:19 (external edit)
Copyright WorkXpress, 2019