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.
Syntax
PSplit(string,n)
Arguments
string is the address line.
n specifies 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"
© 2025 Altair Engineering Inc. All Rights Reserved.