PARSE

Description

Returns the specified token from a string. The tokens are organized between delimiters.

Syntax

PARSE ( TextSourceField, token_number, "delimiters" )

Parameter	Description
TextSourceField	The string from which to return a token.
token_number	The number of the token to return. Empty token positions are counted. Token numbers start at 1.
delimiters	The delimiter(s) that separates each token from the other, allowing each token to be identified.

Remarks

More than one delimiter can be specified, such as space and comma or slash and dash.

If the token that is returned is empty, the return value is an empty string ("").

Examples

This function returns B:

PARSE( "A-B-C", 2, "-" )

This function returns C:

PARSE( "A--C", 3, "-" )

This function returns an empty string:

PARSE ( "X-Y-", 3, "-" )

This function returns 5109:

PARSE( "603/622-5109", 3, "/-" )