This command extracts a string value from the text buffer.
It uses spaces, commas, and tabs to break the text buffer into columns. Any quotation mark pairs that surround the requested column are included in the return value.
Syntax
COL_S column_number
Column_number must be an integer that specifies a column in the text buffer from which to extract data.
Columns are delimited by spaces, commas, and tabs (ASCII code 9).
Return value
This command returns a string.
Notes
To return a column value that does not include any surrounding pairs of quotation marks, use COL_Q.
Examples
COL_S 1
If the text buffer contains the string 'part number xyz', 1.23, abc def , this formula returns the string 'part number xyz' .
By contrast, the COL_Q command returns part number xyz (without the quotation marks).
COL_S 2
If the text buffer contains the string 'part number xyz', 1.23, abc def , this formula returns the string 1.23 .
COL_S 3
If the text buffer contains the string 'part number xyz', 1.23, abc def , this formula returns the string abc .
COL_S 4
If the text buffer contains the string 'part number xyz', 1.23, abc def , this formula returns the string def .