COL2()

COL2()


COL1() Index Level COM
Syntax COL2()
Category BASIC
Type Function
Description returns the numeric column position of the character following the substring retrieved in the most recently executed field function.

The parentheses following the function are required, and contain no arguments.

"col1()" and "col2()" allows non-system delimited strings to be handled like dynamic arrays.  

If the (search) value does not appear in the string being searched by the "field" function, and the field requested is "1", then col2() returns the length of the string.  If the same situation occurs, but the field requested is "2" or higher, then the col2() returns 0.
Options
See Also statements & functions functions FIELD
Example beatles = "john*paul*ringo*george"
name = field(beatles,"*",2)
startpos = col1()    ;*  start.pos is 5
endpos = col2()      ;*  end.pos is 10
beatles = beatles[1,startpos]:beatles[endpos+1,100]

This example has Paul splitting from the Beatles. (To do a solo album).
Warnings
Compatibility D3 7.0 AP R83
COL1() Index Level COM