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"