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