How to Merge Two .xls files side by side into a single .xls


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to Merge Two .xls files side by side into a single .xls
# 1  
Old 08-27-2008
How to Merge Two .xls files side by side into a single .xls

Hi all,
please help me out in below requirement.
I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side
Ex:

abc.xls
Eno Ename
101 hello
102 hero
103 india


bbc.xls

Eno Ename
201 delhi
202 Hyd
203 bombay


My o/p file should be like this

xyz.xls
Eno Ename Eno Ename
101 hello 201 delhi
102 hero 202 Hyd
103 india 203 bombay


between these two one empty column should be there to distinguish..
please help me.. how do we do in unix..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging two text files side by side

Hi everyone, I need to merge two files side by side The files look something like this: HOSTNAME fishtornado-K52F 127.0.1.1 UPTIME 20:17:01 up 2:19, 3 users, load average: 0.00, 0.04, 0.05 DISK USAGE (Size/Used/Avail/Use%) 29G 6.5G 21G 25% RUN QUEUE PID COMMAND USER ... (4 Replies)
Discussion started by: FishTornado
4 Replies

2. UNIX for Dummies Questions & Answers

Paste many files together side by side

Hi, Thank you for your help in advance :D. I have thousands of files like... file01 file02 file03 . . . file6324 I would like to paste every other file side by side so it looks like file01 file02 file03 file04 ...e.t.c file6323 file6324 (3 Replies)
Discussion started by: shaz1990
3 Replies

3. Shell Programming and Scripting

Combining two single column files side-by-side

Hi, I am looking for a sed/awk script to join two large (~300 M) single column files (one is sorted and the other is not sorted) side-by-side. I have a shell script but its taking ages to do the task so looking for an optimized fast solution. The two files look like: File1 (sorted) a1... (1 Reply)
Discussion started by: sajal.bhatia
1 Replies

4. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

5. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies

6. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car... (3 Replies)
Discussion started by: cajunfries
3 Replies

7. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

8. Shell Programming and Scripting

Merge 3 columns side by side

I know this is a stupid question for you guys! half day googling and i got nothing :( i have 3 variables/files, say: $X1 or file1: # there is one whitespace space after each line | 21 | 9 | 28 | 100 | 51 $X2 or file2: # there is one whitespace space... (7 Replies)
Discussion started by: amaulana
7 Replies

9. Shell Programming and Scripting

Merge 2 text files to one text file side by side

Inquiring minds want to know.... I need to take two files that I have latitude and longitude values and then combine them into one file with the values side by side separated by a space. the first file is temp113-lat.txt and the second is temp113-lon.txt. They each have values listed in the... (15 Replies)
Discussion started by: ahinkebein
15 Replies

10. Shell Programming and Scripting

How to Merge Two .xls files side by side into a single .xls

Hi all, please help me out in below requirement. I have two .xls files say abc.xls and bbc.xls , i want to merge these two files into a single file ..say xyz.xls side by side Ex: abc.xls bbc.xls Eno Ename Eno Ename 101 hello ... (2 Replies)
Discussion started by: jagadish99
2 Replies
Login or Register to Ask a Question
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)