COL_S

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.

Also see COLUMN, COL_N

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 .