Sponsored Content
Top Forums Shell Programming and Scripting Help with script to open and compare csv files Post 302439944 by figaro on Sunday 25th of July 2010 07:56:11 AM
Old 07-25-2010
What have you tried so far? It looks like you are asking viewers to look into a problem that has only requirements, but not a suggested approach.
By the way, when trying to open the files on a machine that has only Gnumeric installed, the following message shows:
/tmp/Book1.xls could not be opened, because the associated helper application does not exist. Change the association in your preferences.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to compare csv files using perl

I need to compare 2 csv files and report should containg number of matching lines,different lines ,missing lines in one file using perl. I dont want to use read line by line and scan thru the second file for matching line ,as this logic was so time consuming .Can other ideas .please respond asap... (2 Replies)
Discussion started by: kittu1979
2 Replies

2. Shell Programming and Scripting

Need to compare two csv files values and write into another csv file

Hi all, Am new to scripting. So i just need your ideas to help me out. Here goes my requirement. I have two csv files 1.csv 2.csv abc,1.24 abc,1 def,2.13 def,1 I need to compare the first column of 1.csv with 2.csv and if matches then need to compare... (2 Replies)
Discussion started by: chinnahyd
2 Replies

3. Shell Programming and Scripting

Need to compare values on two CSV files

:( Hello, Having a problem with reading two files using awk/nawk, am new to both them. I need to compare field values between two csv files and arrange for an appropriate output if both the values are equal or not for each feild. $cat File1.csv... (4 Replies)
Discussion started by: pgop
4 Replies

4. Shell Programming and Scripting

open 2 files and compare values script - urgent

Hi gurus I have two csv files that are outputs. The file contains data similar to s.no,number1,number2,date1 -------------------------------- 1, a123,482.29,11/28/07 13:00 2,a124,602.7,9/24/07 14:00 3,a125,266.93,10/9/07 16.48 4,a126,785.15,11/14/07 16:08 <file 2> s.no name... (2 Replies)
Discussion started by: inkyponky
2 Replies

5. Shell Programming and Scripting

Need Perl script to compare two CSV files

Need perl script to compare the two CSV files and and give out put in CSV format File MsPMTP.csv File ProfileNames.csv MsPMTP.csv is having lines like below JBL_VIJ_A_A962/r01sr4sl12/port#01-#13-Au4P-4c-TMi-PMNETR15 JBL_VIJ_A_A962/r01sr4sl12/port#01-#13-Au4P-4c-TMi-PMFETR15... (9 Replies)
Discussion started by: sreedhargouda
9 Replies

6. Shell Programming and Scripting

Compare 2 csv files in ksh and o/p the difference in a new csv file

(say) I have 2 csv files - file1.csv & file2.csv as mentioned below: file1.csv ID,version,cost 1000,1,30 2000,2,40 3000,3,50 4000,4,60 file2.csv ID,version,cost 1000,1,30 2000,2,45 3000,4,55 6000,5,70 The... (7 Replies)
Discussion started by: Naresh101
7 Replies

7. Shell Programming and Scripting

Script to compare count of two csv files

Hi Guys, I need to write a script to compare the count of two csv files each having 5 columns. Everyday a csv file is recived. Now we need to compare the count of todays csv file with yesterday's csv file and if the total count of records is same in todays csv file and yesterday csv file out... (3 Replies)
Discussion started by: Vivekit82
3 Replies

8. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

9. Shell Programming and Scripting

Compare 2 csv files

Hello, I want to compare two csv files expected.csv and actual.csv by fields "f3", "f4", "f5". Field "z" can be differnt. Each record identified by two fields: "number" +"key". Records are not sorted. Can you please help me to get such report: Error: Mismatch in the record... (4 Replies)
Discussion started by: Eugenne
4 Replies

10. Shell Programming and Scripting

Need awk or Shell script to compare Column-1 of two different CSV files and print if column-1 matche

Example: I have files in below format file 1: zxc,133,joe@example.com cst,222,xyz@example1.com File 2 Contains: hxd hcd jws zxc cst File 1 has 50000 lines and file 2 has around 30000 lines : Expected Output has to be : hxd hcd jws (5 Replies)
Discussion started by: TestPractice
5 Replies
GNUMERIC(1)							       GNOME							       GNUMERIC(1)

NAME
gnumeric - a GNOME spreadsheet application. SYNOPSIS
gnumeric [OPTIONS] [files ... ] DESCRIPTION
Gnumeric is a powerful spreadsheet program created by the GNOME project. Gnumeric intends to compete with commercial spreadsheets by becom- ing fully compatible with Microsoft Excel(TM) and through the support of most popular spreadsheet file formats such as Excel(TM), Lotus 1-2-3(TM), Applix(TM), Sylk(TM), XBase(TM), Oleo(TM) and OpenOffice.org formats. Gnumeric supports advanced calculations using statistical, financial and database access functions. Plotting data is supported through an incomplete but powerful plotting system. A plugin system extends gnumeric , for instance enabling the export of data to the LaTeX longtable format. Plugins can be used to define custom functionality. A rudimentary scripting API for the Python language exists and will be extended in the near future. Since gnumeric is free software, gnumeric can also be extended directly at the source code level by any competent programmer. The program can be started from the command line as gnumeric or from one of the menus provided by the underlying platform. When started on the command line, gnumeric may be followed by the options listed below and possibly the names of files in various spreadsheet formats which will then be opened immediately. For instance, the command: gnumeric myfile.gnumeric will launch gnumeric and open the file called "myfile.gnumeric". The default gnumeric file format is in extensible markup language (XML) which subsequently has been compressed with gzip. USER 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 (`--'). Help options -?, --help Show help message. --usage Displays a brief usage message. Gnumeric options -v, --version Displays the version number of the installed instance of gnumeric. --no-splash Start gnumeric without showing the splash screen. The splash screen is normally shown if loading files takes too long. -L, --lib-dir=STRING Set the root library directory to STRING which should be a pathname. -D, --data-dir=STRING Adjust the root data directory to STRING which should be a pathname. Options for window placement -g, --geometry=WIDTHxHEIGHT+XOFF+YOFF Set the size and position of the first window. All units are in pixels. The X offset is from the left hand side of the screen, the Y offset is from the top of the screen. For example, -g=800x600+20+30 will open a gnumeric window 800 pixels wide by 600 pixels high, with the left edge of gnumeric 20 pixels from the left of the screen and the top edge of gnumeric 30 pixels from the top of the screen. --display=DISPLAY X display to use, where DISPLAY has the form machinename:Xdisplay.Screen. Note that the machine displaying gnumeric must have granted the machine running gnumeric the right to display (see xhost). --screen=SCREEN X screen to use, a more compact form of the functionality described above. ADVANCED OPTIONS
GNOME options --disable-sound Disable sound server usage. --enable-sound Enable sound server usage. --espeaker=HOSTNAME:PORT Host:port on which the sound server to use is running. --disable-crash-dialog Disable the bug submission dialog which appears if Gnumeric crashes. GTK options --gdk-debug=FLAGS Gdk debugging flags to set. --gdk-no-debug=FLAGS Gdk debugging flags to unset. --sync Make X calls synchronous. --name=NAME Program name as used by the window manager. --class=CLASS Program class as used by the window manager. --gxid_host=HOST The host on which to contact the gxid daemon. This overrides the GXID_HOST environment variable. This option is only available if GTK+ has been configured with --gdk-target=x11. --gxid_port=PORT The port for the connection to gxid. This overrides the GXID_PORT environment variable. This option is only available if GTK+ has been configured with --gdk-target=x11. --gtk-debug=FLAGS Gtk+ debugging flags to set. --gtk-no-debug=FLAGS Gtk+ debugging flags to unset. --g-fatal-warnings Make all warnings fatal. --gtk-module=MODULE Load an additional Gtk module. Session management options --sm-client-id=ID Specify session management ID. --sm-config-prefix=PREFIX Specify prefix of saved configuration. --sm-disable Disable connection to session manager. VERSION
This manual page describes gnumeric version 1.8. BUGS
For the list of known gnumeric bugs, or to report new ones please visit http://bugzilla.gnome.org. SEE ALSO
ssconvert(1), ssindex(1), ssgrep(1) The Gnumeric Manual Available through the Help menu or online <http://www.gnome.org/projects/gnumeric/doc/gnumeric.shtml>. The Gnumeric Homepage <http://www.gnome.org/projects/gnumeric/>. The GNOME project page <http://www.gnome.org/>. LICENSE
Gnumeric 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 the gnumeric software and source code is held by the individual authors as is documented in the source code. AUTHORS
Gnumeric Jody Goldberg <jody@gnome.org> Miguel de Icaza <miguel@gnome.org> Morten Welinder <terra@gnome.org> -- and many others. For a more complete list, see the About dialog. This manual page Jan Schaumann <jschauma@netmeister.org> Adrian Custer <acuster@gnome.org> gnumeric 2009-02-08 GNUMERIC(1)
All times are GMT -4. The time now is 06:58 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy