Differences

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

Link to this comparison view

expression function - validate city state postal code [2016/09/14 14:19] (current)
Line 1: Line 1:
 +====== 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;
 +
 +{{:​validate_city_state_zip_initial.png?​direct&​600|}}
 +
 +===== Parameters =====
 +The **Validate City State Postal Code** function has three parameters, all of which are required:
 +
 +==== City ====
 +
 +Allowed Inputs: City part of a [[Field|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|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|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 14:19 (external edit)
Copyright WorkXpress, 2019