Linux Commands: Join lines on a common field
join-Linux Command
join command- Join lines on a common field
Syntax: join [Options]... File1 File2
Description: Consider this a special-purpose cousin of paste. This powerful utility allows merging two files in a meaningful fashion, which essentially creates a simple version of a relational database.
The join command operates on exactly two files, but pastes together only those lines with a common tagged field (usually a numerical label), and writes the result to stdout. The files to be joined should be sorted according to the tagged field for the matchups to work properly.
Example:
File: 1.data
100 Shoes
200 Laces
300 Socks
File: 2.data
100 $40.00
200 $1.00
300 $2.00
bash$ join 1.data 2.data
File: 1.data 2.data
100 Shoes $40.00
200 Laces $1.00
300 Socks $2.00
Related: csplit, cut, fmt, fold, head, paste, split, tail
Other Linux Commands:
alias ,
break ,
builtin ,
cal ,
case ,
cat ,
cd ,
cfdisk ,
chgrp ,
chmod ,
chown ,
chroot ,
cksum ,
cmp ,
comm ,
continue ,
cp ,
cron ,
crontab ,
csplit ,
cut ,
date ,
dc ,
dd ,
declare ,
df ,
diff ,
diff3 ,
dir ,
dircolors ,
dirname ,
dirs ,
du ,
echo ,
egrep ,
enable ,
env ,
eval ,
exec ,
expand ,
export ,
expr ,
factor ,
false ,
fdformat ,
fdisk ,
fgrep ,
find ,
fmt ,
fold ,
for ,
fsck ,
function ,
getopts ,
hash ,
hashcharacter ,
head ,
history ,
hostname ,
id ,
if ,
import ,
install ,
join ,
kill ,
less ,
let ,
ln ,
local ,
locate ,
logname ,
logout ,
lpc ,
lpr ,
lprm ,
ls ,
m4 ,
man ,
mbadblocks ,
mkdir ,
mkfifo ,
mknod ,
more ,
mount ,
mtools ,
mv ,
nice ,
nl ,
nohup ,
passwd ,
paste ,
period ,
popd ,
pr ,
printf ,
ps ,
pushd ,
pwd ,
quota ,
quotacheck ,
quotactl ,
ram ,
rcp ,
read ,
readonly ,
return ,
rm ,
rmdir ,
rsync ,
Run ,
sdiff ,
sed ,
select ,
seq ,
set ,
shift ,
shopt ,
shutdown ,
sleep ,
sort ,
split ,
su ,
sum ,
symlink ,
sync ,
tac ,
tail ,
tar ,
tee ,
Test ,
time ,
times ,
top ,
touch ,
tr ,
traceroute ,
true ,
tsort ,
tty ,
Type ,
ulimit ,
umask ,
uname ,
Unexpand ,
uniq ,
units ,
unset ,
unshar ,
until ,
useradd ,
usermod ,
users ,
uuencode ,
watch ,
wc ,
whereis ,
which ,
while ,
who ,
xargs ,
yes ,
Live2Support.com :
