extract-rows

Usage:

crux extract-rows [options] <tsv file> <column name> <column value>

Description:

Given a tab-delimited file, a column name and a column cell value, extract the rows that have the matching values for that column.

Input:

• tsv file – A tab-delimited file, with column headers in the first row. Use "-" to read from standard input.
• column name – A column name.
• column value – A cell value for a column.

Output:

• stdout – the rows for which the value observed in the specified column of the input file match the given on the command line.

Options:

• Input and output

  • --delimiter <string> – Specify the input and output delimiter to use when processing the delimited file. The argument can be either a single character or the keyword 'tab.' Default = tab.
  • --header T|F – Print the header line of the file, in addition to the columns that match. Default = true.
  • --comparison eq|gt|gte|lt|lte|neq – Specify the operator that is used to compare an entry in the specified column to the value given on the command line. Legal values are as follows:
    • eq – The two values are equal
    • lt – The file value is less than the argument value
    • lte – The file value is less than or equal to the argument value
    • gt – The file value is greater than the argument value
    • gte – The file value is greater than or equal to the argument value
    • neq – The file value is not equal to the argument value
    Default = eq.
  • --column-type int|real|string – Specifies the data type of the column, either an integer (int), a floating point number (real), or a string. Default = string.
  • --verbosity <integer> – Specify the verbosity of the current processes. Each level prints the following messages, including all those at lower verbosity levels: 0-fatal errors, 10-non-fatal errors, 20-warnings, 30-information on the progress of execution, 40-more progress information, 50-debug info, 60-detailed debug info. Default = 30.