PARSE Function

Function Type	Predefined function
Syntax	PARSE( <integerReturnPart>, <stringValue>, <regularExpression> )
Description	Parses a string into parts, based on a designated character, and returns the specified part. Parsing is performed on a unique character, such as a space, asterisk, etc. Warning Important Parsing on a character that is part of the actual data may cause erroneous results.
	Argument	Description
	<integerReturnPart>	Part of <stringValue> to be returned. 0 indicates the first part, 1 indicates second part, etc.
	<stringValue>	String to parse.
	<regularExpression>	String (regularExpression) on which to parse.
Returns	String
Example	This example parses the DEPTID field in the Source DEPT table on a space and writes the first part of the parsed field. PARSE(0, Source.DEPT.DEPTID," ")

On this page