DADiSP Worksheet Functions > Function Categories > Data Manipulation and Editing > FINDCOL

 

FINDCOL

Purpose:

Returns the columns that meet a condition.

Syntax:

FINDCOL(condition)

condition

-

A binary series or array.

Returns:

A series, the column numbers that meet the condition.

Example:

W1: ravel(1..12, 4)

W2: findcol(W1 > 7)

 

W1 == {{1, 5,  9},

       {2, 6, 10}, 

       {3, 7, 11}, 

       {4, 8, 12}} 

 

W2 == {2, 3}

 

W2 indicates that columns 2 and 3 contain values that exceed 7.

Remarks:

A column is returned only once even if multiple values meet the condition.

See Also:

DELETECOL

DELMATCH

FIND

FINDROW

INSERTCOL

REPLACECOL