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... (0 Replies)
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)
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)
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)
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)
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)
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)
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)
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
LEARN ABOUT FREEBSD
lam
LAM(1) BSD General Commands Manual LAM(1)NAME
lam -- laminate files
SYNOPSIS
lam [-f min.max] [-s sepstring] [-t c] file ...
lam [-p min.max] [-s sepstring] [-t c] file ...
DESCRIPTION
The lam utility copies the named files side by side onto the standard output. The n-th input lines from the input files are considered frag-
ments of the single long n-th output line into which they are assembled. The name `-' means the standard input, and may be repeated.
Normally, each option affects only the file after it. If the option letter is capitalized it affects all subsequent files until it appears
again uncapitalized. The options are described below:
-f min.max
Print line fragments according to the format string min.max, where min is the minimum field width and max the maximum field width.
If min begins with a zero, zeros will be added to make up the field width, and if it begins with a `-', the fragment will be left-
adjusted within the field.
-p min.max
Like -f, but pad this file's field when end-of-file is reached and other files are still active.
-s sepstring
Print sepstring before printing line fragments from the next file. This option may appear after the last file.
-t c The input line terminator is c instead of a newline. The newline normally appended to each output line is omitted.
To print files simultaneously for easy viewing use pr(1).
EXAMPLES
The command
lam file1 file2 file3 file4
joins 4 files together along each line. To merge the lines from four different files use
lam file1 -S "
" file2 file3 file4
Every 2 lines of a file may be joined on one line with
lam - - < file
and a form letter with substitutions keyed by `@' can be done with
lam -t @ letter changes
SEE ALSO join(1), paste(1), pr(1), printf(3)STANDARDS
Some of the functionality of lam is standardized as the paste(1) utility by IEEE Std 1003.2 (``POSIX.2'').
HISTORY
The lam utility first appeared in 4.2BSD.
BUGS
The lam utility does not recognize multibyte characters.
BSD August 12, 2004 BSD