MoneyWorks Manual
Dice (table, rownum, colnum)
Result Type: Text
Definition: Returns the value of the item in the rownum’th row of the colnum’th column of table.
Examples: If MyTable is:
| A | 1 | 2 |
| B | 3 | 4 |
| C | 5 | 6 |
Dice(MyTable, 1,1) — returns “A”
Dice(MyTable, 2, 3) — returns “4”
See Also:
Head: Get some elements from the start of a delimited string
Left: Get characters from the start of a string
Mid: Get characters from the middle of a string
Regex_GetMatches: Find tokens using a regular expression
Regex_Match: Test whether a string matches a regular expression
Regex_Replace: Replace text in a string using a regular expression
Regex_Search: Find the first match of a regular expression in a string
Regex_SearchStr: Find the first match of a regular expression in a string and return the matching string
RemoveLeading: Remove characters from the start of a string
RemoveTrailing: Remove characters from the end of a string
Replace: Replace matching text in a string with new text
Right: Get characters from the end of a string
Slice: Get a component of a delimited string
Tail: Get some elements from the end of a delimited string
Trim: Remove whitespace from beginning and end of a string