10-24-2014
I would prefer to have a join solution, since I try to frequently use it, but awk will be fine too.. I will try to learn and adapt
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Could anyone help me ?
I'm trying to join two files, but no common field are on them. So I think on generate \000\ sequence to add for each line on both files, so then will be able to join these files.
Any idea?
Thanks in advance, (2 Replies)
Discussion started by: Manu
2 Replies
2. Shell Programming and Scripting
Hello!
I am very new to Linux and I do not know where to begin...
I have a column with >64,000 elements (that are not in numberical order) like this:
name
2
5
9
.
.
.
64,000
I would like to transpose this column into a row that will later become the header of a very large file... (2 Replies)
Discussion started by: doobedoo
2 Replies
3. Shell Programming and Scripting
Hello, i have a few questions which i hope you guys can address. the 1st prob:
The database i am using is a text file which displays the information like this :
Title : Quantity : Price
Persia : 30 : 20
... (5 Replies)
Discussion started by: gregarion
5 Replies
4. Shell Programming and Scripting
Hi All,
I need the command to join 2 lines into one. I found lots of threads but none give me the sollution. Probably because unix scripting is one of my best features ;)
I got a logfile where line 2 needs to be joined with line 1, lines 4 needs to be joined with line 3 etc
If you need... (16 Replies)
Discussion started by: rene21976
16 Replies
5. Shell Programming and Scripting
To give you some context of my issue the following is some sample dummy data. The field delimiter is "<-->". The 4th field is going to be tags for my notes. The tags should always be unique and sorted alphabetically.
1<-->01/20/12<-->01/20/12<-->1st note<-->1st note<-NL->2 lines... (4 Replies)
Discussion started by: adamreiswig
4 Replies
6. Shell Programming and Scripting
I do have many files of the following format.
File_1.txt
1 24
2 25
3 27
4 28
5 29
6 1
File_2.txt
2 5
3 8
4 9
5 10
File_3.txt (3 Replies)
Discussion started by: Lucky Ali
3 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I'm having some trouble joining these two files for some reason. Here is what they look like:
head *
I'm using:
join -a 1 -1 2 -2 1 f1 f2 -t, > joinfile.out
but unfortunately nothing is happening. I did notice that I was having trouble sorting f1 and I'm not sure why using:... (6 Replies)
Discussion started by: verse123
6 Replies
8. Shell Programming and Scripting
Hello masters,
Please help on the following.
I have a tab delimited file with subfields space delimited.
1 a b x y hhghd ghgf
2 v t f g gdgdgdg hghg
I have 3 lookup table files tab delimited, for fields 2,3 and 4 respectively
Lookup2
a 10
b 20
v 30
t 40
Lookup3 (12 Replies)
Discussion started by: ritakadm
12 Replies
9. Shell Programming and Scripting
hello gurus,
Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help.
To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies
10. Shell Programming and Scripting
Hello,
I have 2 csv as follows:
a.csv:
name,phone,adress,car
xy,1234,asbd
yz,2134,asbdf
tc,6789,salkdur
b.csv:
telphone,vehicle
2134,toyota
6789,bmw
1234,honda
What is need is this:
output.csv:
name,phone,adres,car
xy,1234,asbd,honda
yz,2134,asbdf,toyota (7 Replies)
Discussion started by: Zam_1234
7 Replies
LEARN ABOUT DEBIAN
plan9-join
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If one of the file names 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.
Input fields are normally separated spaces or tabs; output fields by space. In this case, multiple separators count as one, and leading
separators are discarded.
The following options are recognized, with POSIX syntax.
-a n In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-v n Like -a, omitting output for paired lines.
-e s Replace empty output fields by string s.
-1 m
-2 m Join on the mth field of file1 or file2.
-jn m Archaic equivalent for -n m.
-ofields
Each output line comprises the designated fields. The comma-separated field designators are either 0, meaning the join field, or
have the form n.m, where n is a file number and m is a field number. Archaic usage allows separate arguments for field designators.
-tc Use character c as the only separator (tab character) on input and output. Every appearance of c in a line is significant.
EXAMPLES
sort /etc/passwd | join -t: -1 1 -a 1 -e "" - bdays
Add birthdays to the /etc/passwd file, leaving unknown birthdays empty. The layout of /adm/users is given in passwd(5); bdays con-
tains sorted lines like
tr : ' ' </etc/passwd | sort -k 3 3 >temp
join -1 3 -2 3 -o 1.1,2.1 temp temp | awk '$1 < $2'
Print all pairs of users with identical userids.
SOURCE
/src/cmd/join.c
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b -ky,y; with -t, the sequence is that of sort -tx -ky,y.
One of the files must be randomly accessible.
JOIN(1)