03-13-2008
question
what type of files will this work on ? I have a need for this script to find terms in documents such as word and excel spreadsheets.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hello
have a file1
H87I
Y788O
T347U
J23U
and
file2 J23U U887Y I99U T556U
file3 I99O J99T F557J
file4 N99I T666U R55Y
file5 H87I T347U
file6 H77U R556Y E44T
file7 Y788O K98U H8I
May be using script we can use file1 to search for all the files
and have the output
H87I file5... (3 Replies)
Discussion started by: cdfd123
3 Replies
2. Shell Programming and Scripting
Hi All,
I have a sql output file has below. I want to get the values 200000040 and 1055.49 .Can anyone help me to write a shell script to get this.
ACCOUNT_NO
------------------------------------------------------------
BILL_NO ... (8 Replies)
Discussion started by: girish.raos
8 Replies
3. Shell Programming and Scripting
Hi Gurus,
I'm a total newbie to Perl and Awk scripting. Let me explain the scenario, there is a DB2 table with 5 columns and one of the column is a CLOB datatype containing XML. We need all the 4 columns but only a portion of string from the XML column.
We decided to export DB2 table to a .del... (26 Replies)
Discussion started by: asandy1234
26 Replies
4. Homework & Coursework Questions
I am aware of the stipulations regarding homework, however I am completely stuck and do not know how to even begin the following (in bash):
Create a script that searches for a text file with most occurrences of a given keyword.
Any help is greatly appreciated.
Thank you (1 Reply)
Discussion started by: hybridoutlaw
1 Replies
5. Shell Programming and Scripting
HI all,
I want to script where all the server names will be in a text file like
server1
server2
server3 . and the script should take servernames from a text file and perform copy of files if the files are not present on those servers.after which it should take next servername till the end of... (0 Replies)
Discussion started by: joseph.dmello
0 Replies
6. Shell Programming and Scripting
Dear all,
I have a database with thousands of files with the structure of name is:
Filename_hour_year.abc
Filename_hour_year_1.abc
..............
So what I need is how to write a script that all file with contain the character "_1" will copy to "_2"
For example: file name:... (7 Replies)
Discussion started by: hainguyen1402
7 Replies
7. Shell Programming and Scripting
This is the ldf file
dn: sdcsmsisdn=1000000049,sdcsDatabase=subscriberCache,dc=example,dc=com
objectClass: sdcsSubscriber
objectClass: top
postalCode: 29600
sdcsServiceLevel: 10
sdcsCustomerType: 14
givenName: Adelia
sdcsBlackListAll: FALSE
sdcsOwnerType: T-Mobile
sn: Actionteam... (1 Reply)
Discussion started by: LinuxFriend
1 Replies
8. Shell Programming and Scripting
Have to read one file say sourcefile containing several words and having another folder containing several files.
Now read the first word of Sourcefile & search it into the folder consisting sevral files, and create another file with result. We hhave to pick the filename of the file in which... (3 Replies)
Discussion started by: mukesh.baranwal
3 Replies
9. Shell Programming and Scripting
Hi guys,
I have a text file named file1.txt that is formatted like this:
001 , ID , 20000
002 , Name , Brandon
003 , Phone_Number , 616-234-1999
004 , SSNumber , 234-23-234
005 , Model , Toyota
007 , Engine ,V8
008 , GPS , OFF
and I have file2.txt formatted like this:
... (2 Replies)
Discussion started by: An0mander
2 Replies
10. Shell Programming and Scripting
Hi Everyone,
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Example input:
IpAdress:InstanceName:Port:ServerName
10.255.255.1:abc:2232:xyz_abc
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
8 Replies
SSGREP(1) GNOME SSGREP(1)
NAME
ssgrep - search spreadsheets for strings
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.
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. For information on this license look at the source code
that came with the software or see the GNU project page <http://www.gnu.org>.
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), ssindex(1)
The Gnumeric Homepage <http://www.gnome.org/projects/gnumeric/>.
The GNOME project page <http://www.gnome.org/>.
gnumeric 2009-02-08 SSGREP(1)