02-13-2013
join -1 1 -2 1- from
join manual page:
Quote:
-1 f Join on field f of file 1. Fields are numbered starting with 1.
-2 f Join on field f of file 2. Fields are numbered starting with 1.
-o 1.1 1.2 1.3 2.3 - from
join manual page:
Quote:
-o list Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a field number.
The common field is not printed unless specifically requested.
This User Gave Thanks to Yoda For This Post:
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i need to combine two file. These two files have the same line number, and i need to combine each corresponding line. I tried the paste, but i need coma as the delimeter. are there anyway to do it? thanks. (4 Replies)
Discussion started by: tao
4 Replies
2. UNIX for Dummies Questions & Answers
Some one plz give me the answer
we have 3 files 1 and 2 are given and we need to get 3 file by using some
trick
file_one.dat
AMITH
ARUN
ARVIND
file_two.dat (these are Variables)
X
Y
Z
and we need to write scirpt in file_two.data and
get the answer in file_three.dat as fallows... (2 Replies)
Discussion started by: Nekki
2 Replies
3. Shell Programming and Scripting
I need a script that combines files with the same name. These files are on a windows directory but the PC has Cygwin so i have a limited unix command set.
What I've got;
WebData_9_2007-09-20.txt
WebData_9_2007-09-20.txt
WebData_9_2007-09-21.txt
WebData_9_2007-09-20.txt... (4 Replies)
Discussion started by: jmwhitford
4 Replies
4. Shell Programming and Scripting
Hi All ,
Any one help me to combine two files in shell scripting .Below is my requrement
i have 2 files as follows
filea
newyork America
Texas America
london Engalad
Fileb
abc
def
xyz
i have to combine this file as follows
newyork America abc
Texas ... (1 Reply)
Discussion started by: ajmalc
1 Replies
5. Shell Programming and Scripting
I have multiple files; each file contains a certain data in a column view
simply i want to combine all those files into one file in columns
example
file1:
a
b
c
d
file 2:
1
2
3
4
file 3:
G (4 Replies)
Discussion started by: ahmedamro
4 Replies
6. UNIX for Dummies Questions & Answers
I need to combine two files based on the content in first column and combine it into one file . For example :
file1:
A 10
B 20
C 30
D 40
File2:
B 200
E 500
A 100
D 400
Need the output in this format:
file 3 :
column 1 Column 2 Column 3
A 10 100
B 20 ... (4 Replies)
Discussion started by: tsm2011
4 Replies
7. Shell Programming and Scripting
Hi,
i have two files. i want to combine records from these two files in below manner :-
first line from first file(1st line)
2nd line from 2nd file(1st line)
3rd line from 1st file(2nd line)
4th line from 2nd file(2nd line)
so on.... (1 Reply)
Discussion started by: deepakiniimt
1 Replies
8. Shell Programming and Scripting
How to cilnd desided output from file1 and file2 with awk.
file1
1 2
7 8 9
14 15 16
21 22 23
28 29 30
file2
aa bb cc
dd ee ff
gg hh ii jj
kk ll (3 Replies)
Discussion started by: theshashi
3 Replies
9. Shell Programming and Scripting
Hello All , I am new to this Forum,
I am trying to write a script to combine two data files with 1 column in common and others columns are different .
File1
Apple 29
tomatao 4
grapes 25
File2
Apple fruit
tomatao veg
grapes fruit
other (3 Replies)
Discussion started by: gagan0119
3 Replies
10. UNIX for Beginners Questions & Answers
i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [-an] [-e s] [-o list] [-tc] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If file1 is `-', the standard
input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Fields are normally separated by blank, tab or newline. In this case, multiple separators count as one, and leading separators are dis-
carded.
These options are recognized:
-an In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-e s Replace empty output fields by string s.
-o list
Each output line comprises the fields specified in list, each element of which has the form n.m, where n is a file number and m is a
field number.
-tc Use character c as a separator (tab character). Every appearance of c in a line is significant.
SEE ALSO
sort(1), comm(1), awk(1).
BUGS
With default field separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.
The conventions of join, sort, comm, uniq, look and awk(1) are wildly incongruous.
7th Edition April 29, 1985 JOIN(1)