Function: PSplit
Description
Reads a string as a postal code and splits it into 3 parts (City, State and Zipcode), then returns the specified substring.
Use this function to work with the Postal Codes within an Address Block. For more information on using and creating Address Blocks refer to Using Address Blocks.
Syntax
PSplit(string,n)
Arguments
string is the address line.
n tells Monarch Classic which substring you want the function to return.
Return value
This function returns a character string.
Calculated field example
If the Postal field contained the value Boston, MA 02145, the following calculated field expression would return 02145: PSplit(Postal,3)
Filter/Find example
Records with a Postal field value of Boston, MA 02145 or Fitchburg, MA 01453 can be selected or found using the expression: PSplit(Postal,2)="MA"
© 2024 Altair Engineering Inc. All Rights Reserved.