Sponsored Content
Full Discussion: using join command
Top Forums Shell Programming and Scripting using join command Post 302363245 by ehshi1992 on Monday 19th of October 2009 07:23:57 PM
Old 10-19-2009
thanks for the quick reply!
but doesn't that simply print it out?
say i want to cat that into a new file and then
with the new file of the two joined, i want to display

Emp # First Name Last Name District Weekly Gross Pay

11234 Sara Smith East 1000.00
12445 Perry Potter South 600.00
23323 Ann Abbott South 924.00
24223 Maple Myers North 630.00
...

is there any way to join the two into a new file?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

join command

Hi, I'm using the join command and it appears to discard certain fields. Here are the two files i'm comparing: File1: 1 a 2 b 3 c 4 d 99 f 101 g 999 i 200 j File 2: 1 e 2 f 3 g 4 h 99 h (22 Replies)
Discussion started by: penfold
22 Replies

2. Shell Programming and Scripting

Join Command Help

Hi, I am trying to use join command for two files of size greater than 1 GB. join -t , -1 2 -2 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,1.10,1.11,1.12,1.13,1.14,1.15,1.16,1.17,1.18,1.19,1.20,1.21,1.22,1.23 File1 File2 > File3 we are facing space crunch after using these join command. May i... (0 Replies)
Discussion started by: jerome Sukumar
0 Replies

3. Shell Programming and Scripting

join (pls help on join command)

Hi, I am a new learner of join command. Some result really make me confused. Please kindly help me. input: file1: LEO oracle engineer 210375 P.Jones Office Runner ID897 L.Clip Personl Chief ID982 S.Round UNIX admin ID6 file2: Dept2C ID897 6 years Dept5Z ID982 1 year Dept3S ID6 2... (1 Reply)
Discussion started by: summer_cherry
1 Replies

4. Shell Programming and Scripting

Join command

Dear Experts, I have several (say 'm') text files, each with 'n' columns. I want to put them into a large single file with n*m columns. a 1 a 1 a 1 a 1 b 2 b 5 b 1 b 3 c 3 c 7 ... (1 Reply)
Discussion started by: Mish_99
1 Replies

5. Shell Programming and Scripting

join command

All, I have 3 files (tab seperated): Note: Please treat dash (-) as empty value in the file, I have added it to make input easily readable file1: (2 cols) A 1 B 2 C 3 file2: (4 cols - col4 has empty values for 4th column except 2nd row) A 1 5 - B 2 6 Y C 3 7 - D 4 8 - file3... (1 Reply)
Discussion started by: bgmmk
1 Replies

6. Shell Programming and Scripting

need help with join command

Hello, I am using join to merge two files together. The defaults usually works great join file1 file2 However, sometimes file1 or file2 has more keys, which I want to keep. file 1: -1 z 0 a 1 b 2 c file 2: 0 a2 1 b2 2 c2 3 c3 So I do join -a1 -a2 file1 file2 But then you don't... (0 Replies)
Discussion started by: ayu
0 Replies

7. Shell Programming and Scripting

awk command for simple join command but based on 2 columns

input1 a_a a/a 10 100 a1 a_a 20 200 b1 b_b 30 300 input2 a_a a/a xxx yyy a1 a1 lll ppp b1 b_b kkk ooo output a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 Replies

8. UNIX for Dummies Questions & Answers

how to join two files using "Join" command with one common field in this problem?

file1: Toronto:12439755:1076359:July 1, 1867:6 Quebec City:7560592:1542056:July 1, 1867:5 Halifax:938134:55284:July 1, 1867:4 Fredericton:751400:72908:July 1, 1867:3 Winnipeg:1170300:647797:July 15, 1870:7 Victoria:4168123:944735:July 20, 1871:10 Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies

9. UNIX for Dummies Questions & Answers

How to use the the join command to join multiple files by a common column

Hi, I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column). I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies

10. UNIX for Dummies Questions & Answers

Join Command

Hi, Please explain the working process of join command. File 1 P B S A C AFile2 C B P A S DBut the output of join command is... join File1.txt File2.txt P B A S A DBut I guess the output should be P B A S A D C A BPlease correct me,if i am worong or missing some thing. Thanks (2 Replies)
Discussion started by: satyar
2 Replies
mapproj(n)							    Tcl Library 							mapproj(n)

__________________________________________________________________________________________________________________________________________________

NAME
mapproj - Map projection routines SYNOPSIS
package require Tcl ?8.4? package require math::interpolate ?1.0? package require math::special ?0.2.1? package require mapproj ?1.0? ::mapproj::toPlateCarree lambda_0 phi_0 lambda phi ::mapproj::fromPlateCarree lambda_0 phi_0 x y ::mapproj::toCylindricalEqualArea lambda_0 phi_0 lambda phi ::mapproj::fromCylindricalEqualArea lambda_0 phi_0 x y ::mapproj::toMercator lambda_0 phi_0 lambda phi ::mapproj::fromMercator lambda_0 phi_0 x y ::mapproj::toMillerCylindrical lambda_0 lambda phi ::mapproj::fromMillerCylindrical lambda_0 x y ::mapproj::toSinusoidal lambda_0 phi_0 lambda phi ::mapproj::fromSinusoidal lambda_0 phi_0 x y ::mapproj::toMollweide lambda_0 lambda phi ::mapproj::fromMollweide lambda_0 x y ::mapproj::toEckertIV lambda_0 lambda phi ::mapproj::fromEckertIV lambda_0 x y ::mapproj::toEckertVI lambda_0 lambda phi ::mapproj::fromEckertVI lambda_0 x y ::mapproj::toRobinson lambda_0 lambda phi ::mapproj::fromRobinson lambda_0 x y ::mapproj::toCassini lambda_0 phi_0 lambda phi ::mapproj::fromCassini lambda_0 phi_0 x y ::mapproj::toPeirceQuincuncial lambda_0 lambda phi ::mapproj::fromPeirceQuincuncial lambda_0 x y ::mapproj::toOrthographic lambda_0 phi_0 lambda phi ::mapproj::fromOrthographic lambda_0 phi_0 x y ::mapproj::toStereographic lambda_0 phi_0 lambda phi ::mapproj::fromStereographic lambda_0 phi_0 x y ::mapproj::toGnomonic lambda_0 phi_0 lambda phi ::mapproj::fromGnomonic lambda_0 phi_0 x y ::mapproj::toAzimuthalEquidistant lambda_0 phi_0 lambda phi ::mapproj::fromAzimuthalEquidistant lambda_0 phi_0 x y ::mapproj::toLambertAzimuthalEqualArea lambda_0 phi_0 lambda phi ::mapproj::fromLambertAzimuthalEqualArea lambda_0 phi_0 x y ::mapproj::toHammer lambda_0 lambda phi ::mapproj::fromHammer lambda_0 x y ::mapproj::toConicEquidistant lambda_0 phi_0 phi_1 phi_2 lambda phi ::mapproj::fromConicEquidistant lambda_0 phi_0 phi_1 phi_2 x y ::mapproj::toAlbersEqualAreaConic lambda_0 phi_0 phi_1 phi_2 lambda phi ::mapproj::fromAlbersEqualAreaConic lambda_0 phi_0 phi_1 phi_2 x y ::mapproj::toLambertConformalConic lambda_0 phi_0 phi_1 phi_2 lambda phi ::mapproj::fromLambertConformalConic lambda_0 phi_0 phi_1 phi_2 x y ::mapproj::toLambertCylindricalEqualArea lambda_0 phi_0 lambda phi ::mapproj::fromLambertCylindricalEqualArea lambda_0 phi_0 x y ::mapproj::toBehrmann lambda_0 phi_0 lambda phi ::mapproj::fromBehrmann lambda_0 phi_0 x y ::mapproj::toTrystanEdwards lambda_0 phi_0 lambda phi ::mapproj::fromTrystanEdwards lambda_0 phi_0 x y ::mapproj::toHoboDyer lambda_0 phi_0 lambda phi ::mapproj::fromHoboDyer lambda_0 phi_0 x y ::mapproj::toGallPeters lambda_0 phi_0 lambda phi ::mapproj::fromGallPeters lambda_0 phi_0 x y ::mapproj::toBalthasart lambda_0 phi_0 lambda phi ::mapproj::fromBalthasart lambda_0 phi_0 x y _________________________________________________________________ DESCRIPTION
The mapproj package provides a set of procedures for converting between world co-ordinates (latitude and longitude) and map co-ordinates on a number of different map projections. COMMANDS
The following commands convert between world co-ordinates and map co-ordinates: ::mapproj::toPlateCarree lambda_0 phi_0 lambda phi Converts to the plate carree (cylindrical equidistant) projection. ::mapproj::fromPlateCarree lambda_0 phi_0 x y Converts from the plate carree (cylindrical equidistant) projection. ::mapproj::toCylindricalEqualArea lambda_0 phi_0 lambda phi Converts to the cylindrical equal-area projection. ::mapproj::fromCylindricalEqualArea lambda_0 phi_0 x y Converts from the cylindrical equal-area projection. ::mapproj::toMercator lambda_0 phi_0 lambda phi Converts to the Mercator (cylindrical conformal) projection. ::mapproj::fromMercator lambda_0 phi_0 x y Converts from the Mercator (cylindrical conformal) projection. ::mapproj::toMillerCylindrical lambda_0 lambda phi Converts to the Miller Cylindrical projection. ::mapproj::fromMillerCylindrical lambda_0 x y Converts from the Miller Cylindrical projection. ::mapproj::toSinusoidal lambda_0 phi_0 lambda phi Converts to the sinusoidal (Sanson-Flamsteed) projection. projection. ::mapproj::fromSinusoidal lambda_0 phi_0 x y Converts from the sinusoidal (Sanson-Flamsteed) projection. projection. ::mapproj::toMollweide lambda_0 lambda phi Converts to the Mollweide projection. ::mapproj::fromMollweide lambda_0 x y Converts from the Mollweide projection. ::mapproj::toEckertIV lambda_0 lambda phi Converts to the Eckert IV projection. ::mapproj::fromEckertIV lambda_0 x y Converts from the Eckert IV projection. ::mapproj::toEckertVI lambda_0 lambda phi Converts to the Eckert VI projection. ::mapproj::fromEckertVI lambda_0 x y Converts from the Eckert VI projection. ::mapproj::toRobinson lambda_0 lambda phi Converts to the Robinson projection. ::mapproj::fromRobinson lambda_0 x y Converts from the Robinson projection. ::mapproj::toCassini lambda_0 phi_0 lambda phi Converts to the Cassini (transverse cylindrical equidistant) projection. ::mapproj::fromCassini lambda_0 phi_0 x y Converts from the Cassini (transverse cylindrical equidistant) projection. ::mapproj::toPeirceQuincuncial lambda_0 lambda phi Converts to the Peirce Quincuncial Projection. ::mapproj::fromPeirceQuincuncial lambda_0 x y Converts from the Peirce Quincuncial Projection. ::mapproj::toOrthographic lambda_0 phi_0 lambda phi Converts to the orthographic projection. ::mapproj::fromOrthographic lambda_0 phi_0 x y Converts from the orthographic projection. ::mapproj::toStereographic lambda_0 phi_0 lambda phi Converts to the stereographic (azimuthal conformal) projection. ::mapproj::fromStereographic lambda_0 phi_0 x y Converts from the stereographic (azimuthal conformal) projection. ::mapproj::toGnomonic lambda_0 phi_0 lambda phi Converts to the gnomonic projection. ::mapproj::fromGnomonic lambda_0 phi_0 x y Converts from the gnomonic projection. ::mapproj::toAzimuthalEquidistant lambda_0 phi_0 lambda phi Converts to the azimuthal equidistant projection. ::mapproj::fromAzimuthalEquidistant lambda_0 phi_0 x y Converts from the azimuthal equidistant projection. ::mapproj::toLambertAzimuthalEqualArea lambda_0 phi_0 lambda phi Converts to the Lambert azimuthal equal-area projection. ::mapproj::fromLambertAzimuthalEqualArea lambda_0 phi_0 x y Converts from the Lambert azimuthal equal-area projection. ::mapproj::toHammer lambda_0 lambda phi Converts to the Hammer projection. ::mapproj::fromHammer lambda_0 x y Converts from the Hammer projection. ::mapproj::toConicEquidistant lambda_0 phi_0 phi_1 phi_2 lambda phi Converts to the conic equidistant projection. ::mapproj::fromConicEquidistant lambda_0 phi_0 phi_1 phi_2 x y Converts from the conic equidistant projection. ::mapproj::toAlbersEqualAreaConic lambda_0 phi_0 phi_1 phi_2 lambda phi Converts to the Albers equal-area conic projection. ::mapproj::fromAlbersEqualAreaConic lambda_0 phi_0 phi_1 phi_2 x y Converts from the Albers equal-area conic projection. ::mapproj::toLambertConformalConic lambda_0 phi_0 phi_1 phi_2 lambda phi Converts to the Lambert conformal conic projection. ::mapproj::fromLambertConformalConic lambda_0 phi_0 phi_1 phi_2 x y Converts from the Lambert conformal conic projection. Among the cylindrical equal-area projections, there are a number of choices of standard parallels that have names: ::mapproj::toLambertCylindricalEqualArea lambda_0 phi_0 lambda phi Converts to the Lambert cylindrical equal area projection. (standard parallel is the Equator.) ::mapproj::fromLambertCylindricalEqualArea lambda_0 phi_0 x y Converts from the Lambert cylindrical equal area projection. (standard parallel is the Equator.) ::mapproj::toBehrmann lambda_0 phi_0 lambda phi Converts to the Behrmann cylindrical equal area projection. (standard parallels are 30 degrees North and South) ::mapproj::fromBehrmann lambda_0 phi_0 x y Converts from the Behrmann cylindrical equal area projection. (standard parallels are 30 degrees North and South.) ::mapproj::toTrystanEdwards lambda_0 phi_0 lambda phi Converts to the Trystan Edwards cylindrical equal area projection. (standard parallels are 37.4 degrees North and South) ::mapproj::fromTrystanEdwards lambda_0 phi_0 x y Converts from the Trystan Edwards cylindrical equal area projection. (standard parallels are 37.4 degrees North and South.) ::mapproj::toHoboDyer lambda_0 phi_0 lambda phi Converts to the Hobo-Dyer cylindrical equal area projection. (standard parallels are 37.5 degrees North and South) ::mapproj::fromHoboDyer lambda_0 phi_0 x y Converts from the Hobo-Dyer cylindrical equal area projection. (standard parallels are 37.5 degrees North and South.) ::mapproj::toGallPeters lambda_0 phi_0 lambda phi Converts to the Gall-Peters cylindrical equal area projection. (standard parallels are 45 degrees North and South) ::mapproj::fromGallPeters lambda_0 phi_0 x y Converts from the Gall-Peters cylindrical equal area projection. (standard parallels are 45 degrees North and South.) ::mapproj::toBalthasart lambda_0 phi_0 lambda phi Converts to the Balthasart cylindrical equal area projection. (standard parallels are 50 degrees North and South) ::mapproj::fromBalthasart lambda_0 phi_0 x y Converts from the Balthasart cylindrical equal area projection. (standard parallels are 50 degrees North and South.) ARGUMENTS
The following arguments are accepted by the projection commands: lambda Longitude of the point to be projected, in degrees. phi Latitude of the point to be projected, in degrees. lambda_0 Longitude of the center of the sheet, in degrees. For many projections, this figure is also the reference meridian of the projec- tion. phi_0 Latitude of the center of the sheet, in degrees. For the azimuthal projections, this figure is also the latitude of the center of the projection. phi_1 Latitude of the first reference parallel, for projections that use reference parallels. phi_2 Latitude of the second reference parallel, for projections that use reference parallels. x X co-ordinate of a point on the map, in units of Earth radii. y Y co-ordinate of a point on the map, in units of Earth radii. RESULTS
For all of the procedures whose names begin with 'to', the return value is a list comprising an x co-ordinate and a y co-ordinate. The co- ordinates are relative to the center of the map sheet to be drawn, measured in Earth radii at the reference location on the map. For all of the functions whose names begin with 'from', the return value is a list comprising the longitude and latitude, in degrees. CHOOSING A PROJECTION
This package offers a great many projections, because no single projection is appropriate to all maps. This section attempts to provide guidance on how to choose a projection. First, consider the type of data that you intend to display on the map. If the data are directional (e.g., winds, ocean currents, or mag- netic fields) then you need to use a projection that preserves angles; these are known as conformal projections. Conformal projections include the Mercator, the Albers azimuthal equal-area, the stereographic, and the Peirce Quincuncial projection. If the data are thematic, describing properties of land or water, such as temperature, population density, land use, or demographics; then you need a projection that will show these data with the areas on the map proportional to the areas in real life. These so-called equal area projections include the various cylindrical equal area projections, the sinusoidal projection, the Lambert azimuthal equal-area projection, the Albers equal-area conic projection, and several of the world-map projections (Miller Cylindrical, Mollweide, Eckert IV, Eckert VI, Robinson, and Hammer). If the significant factor in your data is distance from a central point or line (such as air routes), then you will do best with an equidis- tant projection such as plate carree, Cassini, azimuthal equidistant, or conic equidistant. If direction from a central point is a criti- cal factor in your data (for instance, air routes, radio antenna pointing), then you will almost surely want to use one of the azimuthal projections. Appropriate choices are azimuthal equidistant, azimuthal equal-area, stereographic, and perhaps orthographic. Next, consider how much of the Earth your map will cover, and the general shape of the area of interest. For maps of the entire Earth, the cylindrical equal area, Eckert IV and VI, Mollweide, Robinson, and Hammer projections are good overall choices. The Mercator projection is traditional, but the extreme distortions of area at high latitudes make it a poor choice unless a conformal projection is required. The Peirce projection is a better choice of conformal projection, having less distortion of landforms. The Miller Cylindrical is a compromise designed to give shapes similar to the traditional Mercator, but with less polar stretching. The Peirce Quincuncial projection shows all the continents with acceptable distortion if a reference meridian close to +20 degrees is chosen. The Robinson projection yields attrac- tive maps for things like political divisions, but should be avoided in presenting scientific data, since other projections have moe useful geometric properties. If the map will cover a hemisphere, then choose stereographic, azimuthal-equidistant, Hammer, or Mollweide projections; these all project the hemisphere into a circle. If the map will cover a large area (at least a few hundred km on a side), but less than a hemisphere, then you have several choices. Azimuthal projections are usually good (choose stereographic, azimuthal equidistant, or Lambert azimuthal equal-area according to whether shapes, distances from a central point, or areas are important). Azimuthal projections (and possibly the Cassini projection) are the only really good choices for mapping the polar regions. If the large area is in one of the temperate zones and is round or has a primarily east-west extent, then the conic projections are good choices. Choose the Lambert conformal conic, the conic equidistant, or the Albers equal-area conic according to whether shape, distance, or area are the most important parameters. For any of these, the reference parallels should be chosen at approximately 1/6 and 5/6 of the range of latitudes to be displayed. For instance, maps of the 48 coterminous United States are attractive with reference parallels of 28.5 and 45.5 degrees. If the large area is equatorial and is round or has a primarily east-west extent, then the Mercator projection is a good choice for a con- formal projection; Lambert cylindrical equal-area and sinusoidal projections are good equal-area projections; and the plate carree is a good equidistant projection. Large areas having a primarily North-South aspect, particularly those spanning the Equator, need some other choices. The Cassini projec- tion is a good choice for an equidistant projection (for instance, a Cassini projection with a central meridian of 80 degrees West produces an attractive map of the Americas). The cylindrical equal-area, Albers equal-area conic, sinusoidal, Mollweide and Hammer projections are possible choices for equal-area projections. A good conformal projection in this situation is the Transverse Mercator, which alas, is not yet implemented. Small areas begin to get into a realm where the ellipticity of the Earth affects the map scale. This package does not attempt to handle accurate mapping for large-scale topographic maps. If slight scale errors are acceptable in your application, then any of the projections appropriate to large areas should work for small ones as well. There are a few projections that are included for their special properties. The orthographic projection produces views of the Earth as seen from space. The gnomonic projection produces a map on which all great circles (the shortest distance between two points on the Earth's surface) are rendered as straight lines. While this projection is useful for navigational planning, it has extreme distortions of shape and area, and can display only a limited area of the Earth (substantially less than a hemisphere). KEYWORDS
geodesy, map, projection COPYRIGHT
Copyright (c) 2007 Kevin B. Kenny <kennykb@acm.org> mapproj 0.1 mapproj(n)
All times are GMT -4. The time now is 08:51 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy