Caché MultiValue Basic Reference
COL2
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Returns the FIELD substring end position.
Synopsis
COL2()
Arguments
The COL2 function takes no arguments. The parentheses are mandatory.
Description
The COL2 function returns the ending position for the most recently called FIELD function. 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.
If the FIELD delimiter is not located in string and count=1, COL2 returns the full length of string. If FIELD returns a null string, COL2 returns 0.
The initial COL2 value is 0. The COL2 value is preserved until it is overwritten by the next FIELD function call.
COL2 returns a substring's end delimiter position. COL1 returns a substring's start delimiter position.
Examples
The following example shows the use of the COL2 function:
colors="Red^Green^Blue^Yellow^Orange^Black"
FOR x=1 TO 5
   PRINT FIELD(colors,"^",x)
   PRINT "End delimiter position: ":COL2()
      ! Returns: 4, 10, 15, 22, 29
NEXT
See Also