- 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 - validate city state postal code [2016/09/14 18:19] |
expression function - validate city state postal code [2016/09/14 18: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 |