Manuals/calci/GETCOLUMN

GETCOLUMN (Array,Column)


where

  • is any set of values.
  • is the column number.

Description

  • This function gives the particular column values from the given set of values.
  • In  ,  is the set of values,  is the column number in the given array.
  • So this function displays the specified column values from the given set of values.
  • If we omitted the column number then this function will shows the result as Null for all number of columns.

Examples

  1. GETCOLUMN([[1,2,3],[9,8,7],[10,11,12]],2) = 2 8 11
  2. GETCOLUMN([[13,-12,-90,23,45],[22,-54,-32,-100,65]],3) = -90 -32
  3. GETCOLUMN([[1,4.3,8.9,-56,34,-12,-23],[12,-34,-21,-20,-6.7,9.0]],5) = 34 -6.7

Related Videos

Column

See Also

References