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)
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)
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)
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,
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)
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 PLAN9
road
ROAD(7) Miscellaneous Information Manual ROAD(7)NAME
road, gps - road map of the United States
SYNOPSIS
games/road [ -g ] [ -s scale ]
games/gps
DESCRIPTION
Road displays a road map centered around some specified place in the United States. The data comes from the Census Bureau Tiger Database.
The map is drawn in three shades of grey. Light grey is used for water features such as rivers, streams and lakes. Dark grey is used for
railroads and airports. Black is used for roads. On terminals with ldepth zero, all shades appear black.
Without options, the center of the map is the latitude and longitude specified in the file /lib/sky/here. If the -g option is given, the
center of the map will be the latitude and longitude specified by continually monitoring the end of the file /tmp/gpslog. This file is
written by the GPS satellite receiver program gps. With this option, and with gps running, road becomes a moving map display suitable for
cars or planes.
Keyboard commands
s number
sets the scale of the map to number. The number can be prefixed with + or - to increase/decrease the current scale. Scale 6 is
about one mile across the screen and scale 10 is about ten miles across. Scales 1 through 10 are drawn with maximum detail showing
all roads, trails, rivers, streams and airports. Scales 11 through 14 show highways, rivers, airports and county boundaries.
Scales 15 through 20 show interstate highways and state boundaries.
/regexp
All features labeled by text matching the regular expression are highlighted.
p place
centers the map at the specified place. Usually the place must have the associated state code, (eg murrayhill,nj) but places like
lax and ewr are also known.
l latitude longitude
centers the map at the specified coordinate.
g toggles the -g option described above.
q Exit.
Mouse button commands
Button 1
displays the text of the line nearest the cursor. Normally this is the name of a street or river.
Button 2
displays the text of the place nearest the cursor. Normally this is a town.
Button 3
centers the display on the cursor position.
Gps reads /dev/eia0 assumed connected to a Garmin GPS-55 satellite receiver and writes the current location on the end of the file
/tmp/gpslog. It is intended to be used with mobile PC's.
FILES
/lib/roads/LLLL/LLLLGGGG.h
scale 1-10 database files where LLLL is the latitude multiplied by 5 and GGGG is the longitude multiplied by 5.
/lib/roads/LLL/LLLGGG.h
scale 11-14 database files where LLL is the latitude multiplied by 1 and GGG is the longitude multiplied by 1.
/lib/roads/LL/LLGG.h
scale 15-20 database files where LL is the latitude multiplied by 0.2 and GG is the longitude multiplied by 0.2.
/lib/roads/place
/lib/roads/place.local are the translations between place names and locations. These files must be sorted.
/lib/sky/here
default starting map center.
/tmp/gpslog
moving map location.
SOURCE
/sys/src/games/road
/sys/src/games/gps
ROAD(7)