This command extracts a numeric value from the text buffer.
It uses spaces, commas and tabs to break the text buffer into columns.
Syntax
COL_N 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 number.
Notes
If the value in the specified column is expressed as an exponential number, this command will return the full value of that number.
See also: COL_S, COL_Q, COLUMN
Examples
COL_N 2
If the text buffer contains 01, 123.32, 1234, M22 , this formula returns the number 123.32 .
COL_N 4
If the text buffer contains 01, 123.32, 1234, M22 , this formula returns the number 0 (because M22 is not a numeric value).