GROUP

The GROUP function is equivalent to the FIELD function.

COMMAND SYNTAX

GROUP(Expression1, Expression2, Expression3, Expression4)

SYNTAX ELEMENTS

Expression1 evaluates to the string containing fields to be extracted.
Expression2 evaluates to the character(s) delimiting each field within Expression1.
Expression3 should evaluate to a numeric value specifying the number of the first field to extract from Expression1.
Expression4 evaluates to a numeric value specifying the number of fields to extract as a group.

NOTES

Expression2 may evaluate to more than a single character allowing fields to be delimited with complex expressions.

EXAMPLES

A = "123:-456:-789:-987:-"
CRT GROUP(A, ":-", 2, 2)

This example displays:
456:-789
on the terminal being the second and third fields and their delimiter within variable A.

jBC