[index] : Which field (starting from 1) to look in
operator : What check to do on this field
Operator | Description |
---|---|
== | numerical value must be equal to |
!= | numerical value must be different than |
< | numerical value must be less than |
> | numerical value must be greater than |
<= | numerical value must be less or equal to |
>= | numerical value must be greater or equal to |
include: | must contain the string |
exclude: | must not contain the string |
match_line_in_file: | Value must match any line in the file |
doesnt_match_line_in_file: | Value must not match any line in the file |
Note that the first field's index is 1 (not 0).
./csvql.rb "[1]==toto" "[2]>=12" <<EOF
toto;2
titi;14
toto;12
EOF
toto;12
-v : verbose mode
Displays step by step debug information in addition to matching lines
-q : quiet mode
Displays only matching lines
./csvql.rb -v "[1]>=12" "[2]include:HelloWorld!" "[4]match_line_in_file:/tmp/whitelist.txt"