Differences

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

--- jvs:fscan:manual:chapter2:tabledelete [2014/03/24 15:49]
voyvodic created
+++ jvs:fscan:manual:chapter2:tabledelete [2023/02/23 18:43] (current)
@@ Line 1: / Line 1: @@
 **fScan Reference Manual, Chapter 2 (CmdLineOptions): table_delete**
-===== Table delete -- =====
+===== Table delete -- Deleting a table or table entries=====
-**usage: -table [file] TABLENAME [FLAG] FILENAME**\\
+ **Usage:** -table delete TBLNAME FLAG COL [VALUE1] [VALUE2]
+If TBLNAME is the only argument, the entire table will be deleted.
+With other arguments this will perform a QUERY as described above and only delete those rows that satisfy the query.
+FLAG: Option flags (combine by adding):\\
+ * 4 - VALUE1 is a row number\\
+ * 32 - only delete first instance\\
+ * 64 - VALUE2 is a binary mask to use for COL value\\
+ * 128 - inverse query; search for COL values that don't match; this is automatic if VALUE1 is preceded by '!'\\
+ * 256 - don't display error message on query failure\\
+ * 512 - find COL with missing value (assumed if VALUE1 = 'NULL')\\
+ * 1024 - do not convert 'NULL' in VALUE1 to missing value\\
 **See Also:**\\

Brain Imaging & Analysis Center