10-23-2013
This is the wrong forum, for sure!
I'd just run the xls through xls2txt in shell, get my value, grep for the line number, use sed or a shell loop to grab the right line. Of course, you can do it in PERL, or any other language with xls libraries, but if you do not learn PERL how can you maintain it?
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I need to count the number of files which have a search string, but counting the file only once
if search string is found.
eg: File1: Please note that there are 2 occurances of "aaa"
aaa
bbb
ccc
aaa
File2: Please note that there are 3 occurances of "aaa"
aaa
bbb
ccc... (1 Reply)
Discussion started by: sudheshnaiyer
1 Replies
2. Shell Programming and Scripting
Hi All,
I have a file that I need to be able to find a pattern match on a line, take the number on that line check if its >0.9 or <0.1 and if this is true write the line to output.out file.
An example of 4 lines in my file is:
1. driver.I177.I11.net010 1.48622200477273e-05
2.... (2 Replies)
Discussion started by: Crypto
2 Replies
3. UNIX for Dummies Questions & Answers
I have a couple of things I got stuck on
1)
I have a text file containing 25k search string that I need to search against compressed file. I have used this command but somehow it doesn't seems to use all the search terms.
I have put one search string per line in the txt file (I clean up... (2 Replies)
Discussion started by: m00
2 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
i have a excel sheet with two columns as below.
column1 column2
100 100
200 300
300 400
400 400
500 600
i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these... (2 Replies)
Discussion started by: arunmanas
2 Replies
5. UNIX for Dummies Questions & Answers
Hello I am a new unix user, and I have a work related task to compare 2 files and print all of the lines in file 2 that contain a string from file 1 Note: the fields are in different columns in the files. I suspect the is a good use for awk? Thanks for your time & help
File 1
123 232 W343... (6 Replies)
Discussion started by: KevinRidley
6 Replies
6. Shell Programming and Scripting
Hi,
I have multiple files that each contain one column of strings:
File1:
123abc
456def
789ghi
File2:
123abc
456def
891jkl
File3:
234mno
123abc
456def
In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies
7. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
8. Shell Programming and Scripting
Hi,
Need your help for this scripting issue I have. I am not really good at this, so seeking your help.
I have a file looking similar to this:
Hello, i am human and name=ABCD.
How are you?
Hello, i am human and name=PQRS.
I am good.
Hello, i am human and name=ABCD.
Good bye.
Hello, i... (12 Replies)
Discussion started by: royzlife
12 Replies
9. Shell Programming and Scripting
Hello All
I have a pattern.txt file in source directory ((/project/source/) in linux server and data looks like:
123abc17
234cdf19
235ifg20
I have multiple log files in log directory (/project/log/) in linux server and data for one log file looks like:
<?xml version="1.0" processid... (11 Replies)
Discussion started by: pred55
11 Replies
10. UNIX for Beginners Questions & Answers
Hi All,
I hope somebody would be able to help me.
I would need to search a string coming from a file, example file.txt:
dog
cat
goat
horse
fish
For every string, I would need to know if there are any files inside a directory(recursively) that contains the string regardless of case.... (9 Replies)
Discussion started by: kokoro
9 Replies
GSF(1) GNOME GSF(1)
NAME
gsf - archiving utility using the G Structured File library
SYNOPSIS
gsf [OPTION...] SUBCOMMAND ARCHIVE...
DESCRIPTION
This manual page briefly documents the gsf command.
gsf is a simple archive utility, somewhat similar to tar(1). It operates on files following one of the structured file formats understood
by the G Structured File library, for example, Microsoft Excel(TM) files.
OPTIONS
Options
-?, --help
Show help options
-v, --version
Display gsf's version
Subcommands
cat Output one or more files in archive
dump Dump one or more files in archive as formatted hexadecimal
help List subcommands
list List files in archive
props Archive list of property names
EXAMPLES
To list the content structure of a Microsoft Excel(TM) file arrays.xls:
gsf list arrays.xls
To dump Workbook, an individual data stream in arrays.xls:
gsf dump arrays.xls Workbook
AUTHORS
gsf's primary authors are Morten Welinder <terra@gnome.org> and Jody Goldberg <jody@gnome.org>.
The initial version of this manpage was written by J.H.M. Dassen (Ray) <jdassen@debian.org>.
SEE ALSO
gnumeric(1)
The Gnumeric homepage <http://www.gnome.org/projects/gnumeric/>
The GNOME project page <http://www.gnome.org/>
gsf 29 November 2009 GSF(1)