COL_N

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).