table - run an awk program with a starbase data table as input.

SYNOPSYS

        table   'program' < tablefile

table allows a complete awk language program to be run on a starbase data table input file. The program may be processed for $column name substitutions, header value indexing, and undefined function inclusion but is otherwise unaltered. Column name substitution and header value indexing are controlled with the -h switch. Undefined function inclusion is always done but may be disabled by unsetting the TABLEFUNCTIONS environment variable.

OPTIONS

• -r Read in a starbase data table header. The header is read from the standard input or from a reference file given with the -H option.
• -p Print the starbase data table header on the standard output before executing the awk program. The -p option implies -r.
• -h Use the header read in to make $column substitutions while translating the awk program. The -h option implies -r.
• -i file Read input from file.
• -o file Write output to file.
• -D Print out the awk program to be executed before forking.
• -H Specify an alternate file for the starbase data table header. When the -H option is given the input file should not have a header.

table is the base program for table row manipulation. row, select, calc, reckon, compute and validate are all implemented as links to table.

ENVIRONMENT

• TABLEAWK the name of the awk interpreter to execute. The default interpreter is tawk.
• TABLEFUNCTIONS a path specifying directories to find the source for undefined functions.

  Undefined user written function may be automatically included in the text of programs. The environment variable TABLEFUNCTIONS names a path which is searched for undefined functions. If a function is mentioned in a user program or expression but not defined, a file found in the TABLEFUNCTIONS path with the name of the undefined function will be included in the program. This feature allows a library of usefull functions to be built and accessed easily.

• ARRDEL array delimiter for splitting columns into arrays.

• calc - a command line calcutator
• row, select - select rows from a starbase table
• compute - compute column values for the rows of a starbase data table
• validate - conditionally run statements on the rows of a starbase data table
• reckon - evaluate awk statments as a user program.
• mawk an implementation of the awk programming language by Mike Brennan.
• tawk Awk language extensions implemented at SAO.

• starbase.1 starbase data table introduction.
• starbase.3 starbase data table C library.
• starbase.5 starbase data table file format.