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.
string is the address line.
n tells Monarch Classic which substring you want the function to return.
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)
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"