# 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.