.de URL \\$2 \(laURL: \\$1 \(ra\\$3 .. .if \n[.g] .mso www.tmac .TH SSGREP 1 "2009-02-08" gnumeric "GNOME" .SH NAME ssgrep \- search spreadsheets for strings .SH SYNOPSIS \fBssgrep \fR [\fIOPTIONS\fR] [\fIFILES\fR] .SH DESCRIPTION This manual page briefly documents the \fBssgrep\fR command. \fBssgrep\fR is a command line utility to search for strings in spreadsheets of any format supported by gnumeric. Without any output modifying options, \fBssgrep\fR prints one line for each match. A match consists of the matching content of a cell or, if the \fB\-R\fR option is given, the matching expression result of a cell. .\".SH "RETURN VALUE" .\".SH "EXIT STATUS" .\".SH ERRORS .SH 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 (`--'). .SS "Options controlling input file handling" .TP .B \-\-recalc Recalculate all cells .SS "Options controlling patterns and pattern matching" .TP .B \-f, \-\-keyword\-file=\fIFILE\fR The path to a text file containing one key per line .TP .B \-i, \-\-ignore\-case Ignore differences in letter case .TP .B \-w, \-\-word\-regexp Match only whole words .TP .B \-F, \-\-fixed\-strings Pattern is a set of fixed strings .TP .B \-R, \-\-search\-results Search results of expressions too .TP .B \-v, \-\-invert-match Search for cells that do not match .SS "Options controlling output in general" .TP .B \-c, \-\-count Only print a count of matches per file .TP .B \-L, \-\-files\-without\-matches Print filenames without matches .TP .B \-l, \-\-files\-with\-matches Print filenames with matches .TP .B \-q, \-\-quiet Suppress all normal output .TP .B \-H, \-\-with\-filename Print the filename for each match .TP .B \-h, \-\-without\-filename Do not print the filename for each match .TP .B \-n, \-\-print\-locus Print the location of each match .TP .B \-T, \-\-print\-type Print the location type of each match .SS "Help options" .TP .B \-V, \-\-version Display ssgrep's version .TP .B \-?, \-\-help Display the supported options .TP .B \-\-usage Display a brief usage message .\".SH USAGE .SH EXAMPLE To search for the string "SUM" in the file \fIfoo.gnumeric\fR : .PP \fBssgrep\fR \fISUM\fR \fIfoo.gnumeric\fR .PP To search for the strings from the file \fIkeywords\fR in the spreadsheet \fIfoo.xls\fR : .PP \fBssgrep\fR \fB\-\-keyword\-file=\fIkeywords\fR \fIfoo.xls\fR .PP .\".SH FILES .\".SH ENVIRONMENT .\".SH DIAGNOSTICS .\".SH SECURITY .\".SH CONFORMING TO .\".SH NOTES .\".SH BUGS .SH LICENSE \fBssgrep\fR is licensed under the terms of the General Public License (GPL), version 2 or 3. For information on this license look at the source code that came with the software or see the .URL "http://www.gnu.org" "GNU project page" . .SH COPYRIGHT The copyright on \fBssgrep\fR and the \fBgnumeric\fR software and source code is held by the individual authors as is documented in the source code. .SH AUTHOR \fBssgrep\fR's primary author is Jody Goldberg ; \fBssgrep\fR builds on the \fBgnumeric\fR codebase. The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) . .SH SEE ALSO \fBbeagled\fR(1), \fBgnumeric\fR(1), \fBssconvert\fR(1), \fBssdiff\fR(1) \fBssindex\fR(1) .URL "http://www.gnome.org/projects/gnumeric/" "The Gnumeric Homepage" . .URL "http://www.gnome.org/" "The GNOME project page" .