FIELD Function

Reality will accept an alternative syntax for the FIELD function, whereby it will accept an optional fourth parameter. If supplied, this parameter must contain the number of fields to return (default 1); cf. the GROUP function.

Syntax

FIELD(string-expr, delimiter, start-field{, no-of-fields})