Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

FIELDS Function (DataBasic) (m618703+fields_f.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

FIELDS Function

Returns one or more character-delimited fields from within each element of a dynamic array.

Syntax

FIELDS(dynArray, delimiter, fieldNumber{, numFields})

Syntax Elements

dynArray A DataBasic expression that evaluates to a dynamic array.

delimiter The character used as a field delimiter. If delimiter contains more than one character, only the first is used.

fieldNumber A positive integer specifying which field to return. The fields are numbered starting from 1. If the field number is less than 1, field 1 is returned.

numFields Optional. The number of fields, starting at fieldNumber, to return from each element (default, 1). If numFields is less than 1 or an empty string, the default is used.

Return Value

A dynamic array with the same structure as dynArray, but with each element replaced by the field(s) extracted from that element.

If delimiter is a empty string, an empty string is returned.

If fieldNumber is greater than the number of fields in the element concerned, that element is returned as an empty string (note that if delimiter cannot be found there is effectively just one field in the element).

If numFields is greater than 1, the extracted fields are separated by delimiter.

Case Insensitivity

If data case insensitive mode is selected (see Case Sensitivity), case is ignored when searching elements for delimiter.

Example

ARY = "XXX:YYY:ZZZ:555":@AM:"AAA:BBB:CCC":@AM:"Paul:Jane:John:David"
NEWARY = FIELDS(ARY, ":", 3)