FIELDS

The FIELDS function is an extension of the FIELD function. It returns a dynamic array of multi-character delimited fields from a dynamic array of strings.

COMMAND SYNTAX

FIELDS(DynArr, Delimiter, Occurrence{, ExtractCount})

SYNTAX ELEMENTS

DynArr should evaluate to a dynamic array.
Delimiter specifies the character or characters that delimit the fields within the dynamic array.
Occurrence should evaluate to an integer of value 1 or higher. It specifies the delimiter used as the starting point for the extraction.
ExtractCount is an integer that specifies the number of fields to extract. If omitted, 1 is assumed.

NOTES

If the emulation option jbase_field is set then the field delimiter may consist of more than a single character, allowing fields to be delimited by complex codes.

If extractCount is greater than 1 then only the first character of delimiter is used, regardless of the setting of jbase_field.

EXAMPLES

The following program shows how each element of a dynamic array can be changed with the FIELDS function.

t = ""
t<1> = "a:b:c:d:e:f"
t<2> = "aa:bb:cc:dd:ee:ff" : @VM: "1:2:3:4" : @SVM: ":W:X:Y:Z"
t<3> = "aaa:bbb:ccc:ddd:eee:fff":@VM:@SVM
t<4> = "aaaa:bbbb:cccc:dddd:eeee:ffff"

r1 = FIELDS(t,":",2)
r2 = FIELDS(t,":",2,3)
r3 = FIELDS(t,"bb",1,1)

The above program creates 3 dynamic arrays. v represents a value mark. s represents a sub-value mark.

jBC