Caché MultiValue Basic Reference
Returns the FIELD substring start position.
function takes no arguments. The parentheses are mandatory.
function returns the starting position for the most recently called FIELD
extracts a substring from a string by specifying a delimiter character. The specified delimiter immediately precedes the extracted substring. COL1
returns the string position (counting from 1) of this delimiter character.
The initial COL1
value is 0. The COL1
value is preserved until it is overwritten by the next FIELD
returns a substring's start delimiter position. COL2
returns a substring's end delimiter position.
The following example shows the use of the COL1
FOR x=1 TO 5
PRINT "Start delimiter position: ":COL1()
! Returns: 0, 4, 10, 15, 22