ssgrep1
Search spreadsheets for strings
Usage
ssgrep [OPTIONS]
[FILES]
Overview
This manual page briefly documents the ssgrep command.
ssgrep is a command line utility to search for strings in spreadsheets of any format supported by gnumeric. Without any output modifying options, ssgrep prints one line for each match. A match consists of the matching content of a cell or, if the -R option is given, the matching expression result of a cell.
Options
This program follows the usual GNU command line syntax, with single letter options starting with a single dash (`-') and longer options starting with two dashes (`--').
Options controlling input file handling
-
--recalc -
Recalculate all cells
Options controlling patterns and pattern matching
-
-f, --keyword-file=FILE -
The path to a text file containing one key per line
-
-i, --ignore-case -
Ignore differences in letter case
-
-w, --word-regexp -
Match only whole words
-
-F, --fixed-strings -
Pattern is a set of fixed strings
-
-R, --search-results -
Search results of expressions too
-
-v, --invert-match -
Search for cells that do not match
Options controlling output in general
-
-c, --count -
Only print a count of matches per file
-
-L, --files-without-matches -
Print filenames without matches
-
-l, --files-with-matches -
Print filenames with matches
-
-q, --quiet -
Suppress all normal output
-
-H, --with-filename -
Print the filename for each match
-
-h, --without-filename -
Do not print the filename for each match
-
-n, --print-locus -
Print the location of each match
-
-T, --print-type -
Print the location type of each match
Help options
-
-V, --version -
Display ssgrep's version
-
-?, --help -
Display the supported options
-
--usage -
Display a brief usage message
Examples
To search for the string "SUM" in the file foo.gnumeric :
ssgrep SUM foo.gnumeric
To search for the strings from the file keywords in the spreadsheet foo.xls :
ssgrep --keyword-file=keywords foo.xls
Releases
9 releases since Debian 6.0 (Squeeze); the text changed 3 times.