User Tools

Site Tools


jvs:fscan:manual:chapter2:table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
jvs:fscan:manual:chapter2:table [2014/03/24 15:56]
voyvodic
jvs:fscan:manual:chapter2:table [2023/02/23 18:43] (current)
Line 5: Line 5:
   * **-table [show]**\\   * **-table [show]**\\
   * **-table TABLENAME**\\   * **-table TABLENAME**\\
-  * [[jvs:fscan:manual:chapter2:tablefile|**-table [file] TABLENAME [FLAG] FILENAME**]]\\ +  * **[[jvs:fscan:manual:chapter2:tablefile|-table [file] TABLENAME [FLAG] FILENAME]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tableshow|**-table [show] TABLENAME [FLAG][FILENAME]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tableshow|-table [show] TABLENAME [FLAG] [ROW] [NROWS] [FILENAME] ]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tablequery|**-table query TABLENAME [FLAG] NEWNAME COL [VALUE1] [VALUE2]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tableset|-table set TABLENAME VALUE COL [ROW[NROWS]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tabledelete|**-table delete TABLENAME [FLAG] [COL] [VALUE1] [VALUE2]**]]\\+  * **[[jvs:fscan:manual:chapter2:tablequery|-table query TABLENAME [FLAG] NEWNAME COL [VALUE1] [VALUE2] ]]**\\ 
 +  * **[[jvs:fscan:manual:chapter2:tabledelete|-table delete TABLENAME [FLAG] [COL] [VALUE1] [VALUE2] ]]**\\
   * **[[jvs:fscan:manual:chapter2:tableref|-table [reference] TABLENAME [FLAG] REFNAME]]**\\   * **[[jvs:fscan:manual:chapter2:tableref|-table [reference] TABLENAME [FLAG] REFNAME]]**\\
   * **[[jvs:fscan:manual:chapter2:tableglossary|-table [glossary] TABLENAME [FLAG] GLOSSARYNAME]]**\\   * **[[jvs:fscan:manual:chapter2:tableglossary|-table [glossary] TABLENAME [FLAG] GLOSSARYNAME]]**\\
-  * [[jvs:fscan:manual:chapter2:tabledataset|**-table dataset TABLENAME [FLAG]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tabledataset|-table dataset TABLENAME [FLAG] ]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tablewindow|**-table window TABLENAME [FLAG]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tablewindow|-table window TABLENAME [FLAG] ]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tabledir|**-table directory TBLNAME [FLAG] DIRNAME [MATCHSTRING [TBL2NAME]]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tabledir|-table directory TBLNAME [FLAG] DIRNAME [MATCHSTRING[TBL2NAME]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tableconfig|-table configure TBLNAME [FLAG] COLNAME [TYPE] [COLNUM] [COLNAME [TYPE] [COLNUM]] ...]]\\ +  * **[[jvs:fscan:manual:chapter2:tableconfig|-table configure TBLNAME [FLAG] COLNAME [TYPE] [COLNUM] ... [COLNAME TYPE COLNUM] ]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tablecopy|**-table copy TBLNAME [FLAG] NEWNAME [nrows NROWS] ]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tablecopy|-table copy TBLNAME [FLAG] NEWNAME [nrows NROWS]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tablesort|**-table sort TBLNAME FLAG SORTCOL**]]\\ +  * **[[jvs:fscan:manual:chapter2:tablesort|-table sort TBLNAME FLAG SORTCOL]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tablemerge|**-table merge TBLNAME FLAG TBL2NAME MERGECOL**]]\\ +  * **[[jvs:fscan:manual:chapter2:tablemerge|-table merge TBLNAME FLAG TBL2NAME MERGECOL]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tableprintf|**-table printf TBLNAME FLAG FORMATSTR [OUTFILE]**]]\\ +  * **[[jvs:fscan:manual:chapter2:tableprintf|-table printf TBLNAME FLAG FORMATSTR [OUTFILE] ]]**\\ 
-  * [[jvs:fscan:manual:chapter2:tableinvivo|**-table invivo TBLNAME FLAG NAME**]]\\+  * **[[jvs:fscan:manual:chapter2:tablecmd|-table command TBLNAME FLAG [PATH] CMD [DATACOL] [CMDCOL] [ARGCOL] ]]**\\ 
 +  * **[[jvs:fscan:manual:chapter2:invivo|-table invivo TBLNAME FLAG NAME]]**\\
  
 The TABLE command is used for loading, querying, and displaying tables. Tables are multi-column data sets where each column can contain either text strings or number values. Tables can be loaded from text files, or by extracting information from different internal data lists (e.g. data set names, window names, reference time course condition names, glossary names). When loading tables, the type of data source can be identified explicitly using the first argument (e.g. file, reference, glossary, dataset, window) or implicitly using the FILENAME/REFNAME/GLOSSARYNAME argument (if the argument is unrecognized, "file" is assumed).  The TABLE command is used for loading, querying, and displaying tables. Tables are multi-column data sets where each column can contain either text strings or number values. Tables can be loaded from text files, or by extracting information from different internal data lists (e.g. data set names, window names, reference time course condition names, glossary names). When loading tables, the type of data source can be identified explicitly using the first argument (e.g. file, reference, glossary, dataset, window) or implicitly using the FILENAME/REFNAME/GLOSSARYNAME argument (if the argument is unrecognized, "file" is assumed). 
Line 66: Line 68:
   * 040 - tab separated columns   * 040 - tab separated columns
   * 0100 - only show up to 10 rows of data   * 0100 - only show up to 10 rows of data
-  * 0200 - show no data, only header +  * 0200 - replace missing values with '0' 
-  * 0400 - show row sorting index if available+  * 0400 - show no data, only header 
 +  * 01000 - show row sorting index if available
 ====Configuring a table==== ====Configuring a table====
 The CONFIGURE option can be used to re-configure an existing table (or create a new empty table). It is intended for adding column names, adding whole columns, moving existing columns, or removing columns. Columns to be modified are specified as triplets of "name type colnum" (of these only the name is required). Multiple column specifications can be combined in a single command. The CONFIGURE option can be used to re-configure an existing table (or create a new empty table). It is intended for adding column names, adding whole columns, moving existing columns, or removing columns. Columns to be modified are specified as triplets of "name type colnum" (of these only the name is required). Multiple column specifications can be combined in a single command.
jvs/fscan/manual/chapter2/table.1395676594.txt.gz · Last modified: 2014/08/04 16:03 (external edit)