3.5.8.12 Idx

Description

Evaluates conditional expression involving a single vector and returns a vector of integers containing the row indices of all records that meet the condition.

Syntax

vector idx(bool vbool)

Parameters

vbool

a conditional expression on a single vector

Return

Returns a vector of integers containing the row indices of all records that meet the condition.

Examples

idx(B==100) // Returns indices of values in B that equal 100
idx(B>=20 && B<=50) // Returns indices of values in B are between 20 and 50
idx(left(A,5)\$ == "Chris") // Returns indices of values in A where first 5 letters are "Chris"