Edit

TableFind (table, key)

Result Type: Number

Definition: Find the row number in the table identified by key. The first row is considered a heading, and is ignored. You can use Slice or Dice to extract data.

Examples: If MyTable is “A\t1\t2\nB\t3\t4\n\C\t5\t6”, as shown below:

A12
B34
C56

TableFind(MyTable, "C") — returns 3

TableFind(MyTable, "D") — returns 0 (not found)

See Also:

CreateTable: Create an empty accumulator table

Sort: Sort a delimited tabular string

TableAccumulate: Accumulate numeric column data for a key

TableAccumulateColumn: Accumulate data in one column for a key

TableGet: Extract data for a key or index found with TableFind

Transpose: Transpose a tabular delimited string