tables


cell

tables

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

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

tables

table (word) | column (number)

list

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

show column "table 5


erasetable

tables

table (word)

none

Erases the named table.

erase "mytable


loadtable

tables

tablename (word) | filename (word)

none

Loads the specified filename from disk into the specified table.

loadtable "mytable "mytable.tbl


newtable

tables

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

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

tables

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

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

tables

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

none

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

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


replacerow

tables

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

none

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

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


replacetable

tables

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

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

tables

tablename | row

list

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

show row "mytable 5


savetable

tables

tablename (word) | filename (word)

none

Saves the specified table to disk using the specified filename.

savetable "mytable "mytable.tbl


scol

tables

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

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

tables

table (word) | sheet (number)

none

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

setsheet "table 2


sheet

tables

table (word)

sheet (number)

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

show sheet "table


sort

tables

tablename (word) | column (number)

none

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

sort "table 3


srow

tables

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

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

tables

name (word)

list

Returns the contents of the named table as a list.

show table "mytable


tables

tables

none

none

Returns a list of the currently defined tables.

show tables


tablesize

tables

name (word)

list

Returns a list of the dimensions of the named table.

show tablesize "mytable