tables

cell

Takes:   table (word) | [row column (sheet)]

Returns:   value

Returns the value stored in the specified table at the specified row, column, and sheet (if provided). See putcell

show cell "table [3 4]
20

column

Takes:   table (word) | column (number)

Returns:   list

Returns the contents of the specified column in the specified table as a list. See row

show column "table 5

erasetable

Takes:   table (word)

Returns:   none

Erases the named table.

erase "mytable

loadtable

Takes:   tablename (word) | filename (word)

Returns:   none

Loads the specified filename from disk into the specified table.

loadtable "mytable "mytable.tbl

newtable

Takes:   name “word | [rows columns (sheets)] (list)

Returns:   none

Creates a new table of the provided dimensions. Note that the dimensions are provided as a list of two (or three) numbers. If a number of sheets (third number) is provided, a third sheet number must also be provided in cell and setcell, and setsheet must be used to specify the sheet number for the srow, scol, replacerow, replacecolumn, row and column primitives. See setcell

newtable "mytable [3 20]

putcell setcell

Takes:   table (word) | [row column (sheet)] (list) | value

Returns:   none

Sets the cell in the table with the provided name to the provided value. If no sheet number is provided, setcell will default to sheet 1, if the table has multiple sheets. See cell

setcell "table [4 5] 20
setcell "table3 [4 5 2] 30

replacecolumn

Takes:   name (word) | list of cell contents (list)

Returns:   none

Replaces a column in the named table with the provided list of cells.

replacecolumn "table [1 2 3 4 5 6 7]

replacerow

Takes:   name (word) | list of cell contents (list)

Returns:   none

Replaces a row in the named table with the provided list of cells.

replacerow "table [1 2 3 4 5 6 7]

replacetable

Takes:   name (word) | list of table contents (list)

Returns:   none

Replaces the contents of a table with the provided list of cells. See table

replacerow "table [[1 2 3] [1 2 3] [1 2 3]]

row

Takes:   tablename | row

Returns:   list

Returns the entire specified row of the specified table, formatted as a list. See column=

show row "mytable 5

savetable

Takes:   tablename (word) | filename (word)

Returns:   none

Saves the specified table to disk using the specified filename.

savetable "mytable "mytable.tbl

scol

Takes:   table (word) | [column value (variance)] (list)

Returns:   list

Searches a given column in the given table for the given value, within the optionally provided variance if numeric. See srow

show scol "table [4 6 2]

setsheet

Takes:   table (word) | sheet (number)

Returns:   none

Sets the ‘sheet’ (third dimension) used by the table commands srow, scol, replacerow, replacecolumn, row and column

setsheet "table 2

sheet

Takes:   table (word)

Returns:   sheet (number)

Returns the current sheet number for the given table. See setsheet

show sheet "table

sort

Takes:   tablename (word) | column (number)

Returns:   none

Sorts the specified table on the given column, low to high.

sort "table 3

srow

Takes:   table (word) | [row value (variance)] (list)

Returns:   list

Searches a given row in the given table for the given value, within the optionally provided variance if numeric. See scol

show srow "table [4 6 2]

table

Takes:   name (word)

Returns:   list

Returns the contents of the named table as a list.

show table "mytable

tables

Takes:   none

Returns:   none

Returns a list of the currently defined tables.

show tables

tablesize

Takes:   name (word)

Returns:   list

Returns a list of the dimensions of the named table.

show tablesize "mytable