GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  SSGREP (1)

NAME

ssgrep - search spreadsheets for strings

CONTENTS

Synopsis
Description
Options
Example
License
Copyright
Author
See Also

SYNOPSIS

ssgrep [OPTIONS] [FILES]

DESCRIPTION

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

EXAMPLE

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

LICENSE

ssgrep 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 GNU project page \(laURL: http://www.gnu.org \(ra.

COPYRIGHT

The copyright on ssgrep and the gnumeric software and source code is held by the individual authors as is documented in the source code.

AUTHOR

ssgrep’s primary author is Jody Goldberg <jody@gnome.org>; ssgrep builds on the gnumeric codebase.

The initial version of this manpage was based on ssindex.1 by J.H.M. Dassen (Ray) <jdassen@debian.org>.

SEE ALSO

beagled(1), gnumeric(1), ssconvert(1), ssdiff(1) ssindex(1)

The Gnumeric Homepage \(laURL: http://www.gnome.org/projects/gnumeric/ \(ra.

The GNOME project page \(laURL: http://www.gnome.org/ \(ra.

Search for    or go to Top of page |  Section 1 |  Main Index


gnumeric SSGREP (1) 2009-02-08

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.