MoneyWorks Manual
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:
| A | 1 | 2 |
| B | 3 | 4 |
| C | 5 | 6 |
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