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 DEBIAN
llsearch
LLSEARCH(1) General Commands Manual LLSEARCH(1)NAME
llsearch - Search a GNIS file for place names within a given block of latitude/longitude
SYNOPSIS
llsearch [-L] | [latitude_low longitude_low latitude_high longitude_high]
DESCRIPTION
The U.S. Geological Survey supports sites on the Internet with Geographic Names Information System (GNIS) files. These files contain lists
of place names, complete with their latitude/longitude and other information. There are separate files for each of the U.S. states, and
each file contains many, many, many place names. If you want to use this data with drawmap, it is useful to reduce the data to only the
items that you need. Llsearch lets you filter a GNIS file and winnow out only those place names that fall within the latitude/longitude
boundaries that you specify. (You may want to specify boundaries that are a tiny bit larger than what you are interested in, so that
numerical quantization doesn't eliminate locales that fall exactly on your boundaries.)
Latitudes and longitudes are positive for north latitude and east longitude, and negative for south latitude and west longitude. Llsearch
expects you to enter them in decimal degrees. (The latitudes and longitudes in the GNIS file are in degrees-minutes-seconds format, fol-
lowed by 'N', 'S', 'E', or 'W'. However, there are two available file formats, and one of the formats also contains the latitudes/longi-
tudes in decimal degrees.) Typical usage is as follows:
gunzip -c california.gz | llsearch 33 -118 34 -117 > gnis_santa_ana_west
If you enter the "-L" option, the program will print some license information and exit.
Once you have reduced the data to some subset of interest, you can search for particular items via the grep or perl commands, or other
search commands, or you can simply edit the results with your favorite text editor. Search commands are useful in reducing the sheer vol-
ume of data to a more manageable size (by extracting, say, all mountain summits or all streams), but you will probably ultimately end up
looking through the remaining data manually. The individual records contain codes, such as "ppl" for populated places, and "summit" for
mountain tops, that can help you pick and choose.
There is considerable redundancy in place names, and human intelligence is useful in sorting things out. While I was writing drawmap and
llsearch, I frequently gazed out my office window, where I could spot at least two, and possibly three Baldy Mountains. There are also
quite a few Beaver Creeks, Bear Canyons, Saddle Buttes, and Springfields out there. By taking a close look at the information associated
with each place name, you can find the particular locations that interest you.
SEE ALSO drawmap(1)
Jul 24, 2001 LLSEARCH(1)