VA FileMan V. 22.0 Advanced User Manual: $P[IECE] VA FileMan Function

Contents:

Main

Format:	$P(string,"delimiter",n) $P(string,"delimiter",n1,n2) $P(string,"delimiter")
Parameters:	string is a string expression. delimiter is a character (or characters) or an expression yielding a character (or characters) that divides the string into pieces. n, n1, and n2 are positive integers or expressions evaluating to positive integers.
Use:	The function returns a part of string. String is divided into substrings by delimiter. In the first format, the n^th substring is returned. In the second format, the substrings starting with n1 and ending with n2 are returned. The delimiters between those substrings are also returned. In the third format, the first substring (i.e., the one preceding the first occurrence of delimiter) is returned.
Examples:	$P("McMillan,John",",",2)=> John $P(PHONE,"-",2,3)=> 943-2109 $P(PHONE,"-")=> 510

Reviewed/Updated: March 4, 2007