UNIX for Dummies Questions & Answers

awk 'NR==FNR{T[$1,$2]=$3; next} {print $0, T[$2,$1]}' test.txt > test_out.txt

awk 'NR==FNR{T[$1,$2]=$3; next} {print $0, T[$2,$1]}' test.txt test.txt > test_out.txt

awk 'NR==FNR{T[$1,$2]=$3; next} {print $0, T[$2,$1]+0}' test.txt test.txt

A	A	200
A	B	100
A	C	90
B	B	203
B	A	101
B	C	87
C	C	300
C	A	91
C	B	86

A	A	200
 200
A	B	100
 101
A	C	90
 91
B	B	203
 203
B	A	101
 100
B	C	87
 86
C	C	300
 300
C	A	91
 90
C	B	86
 87

 0

A	A	200     0
A	B	100     101
A	C	90     91
B	B	203     0
B	A	101     100
B	C	87     86
C	C	300     0
C	A	91     90
C	B	86     87

A    A    200   200
A    B    100    101

$ awk 'BEGIN{T["NaN"]=0}NR==FNR{T[$1 FS $2]=$3; next} {print $0, T[$2 FS $1 == $1 FS $2 ? "NaN": $2 FS $1]}' file file

$ awk 'NR==FNR{T[$1 FS $2]=$3; next} {print $0, $1 FS $2 == $2 FS $1 ? 0 : T[$2 FS $1]}' file fle

A	A	200 0
A	B	100 101
A	C	90 91
B	B	203 0
B	A	101 100
B	C	87 86
C	C	300 0
C	A	91 90
C	B	86 87

awk 'NR==FNR{T[$1,$2]=$3; next} NF{print $0, ($1 == $2) ? 0 : T[$2,$1]+0}'  file file

#!/usr/bin/env bash

# @(#) s1	Demonstrate join of first 2 columns, ignoring order of tokens.

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
# export PATH="/usr/local/bin:/usr/bin:/bin"
pe() { for _i;do printf "%s" "$_i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for _i;do printf "%s" "$_i";done;printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && $C awk sed

FILE=${1-data1}

pl " Input data file $FILE:"
cat $FILE

pl " Results:"
awk '
	{ if ( $1 < $2 ) {
	  first = $1 ; second = $2
	} else {
	  first = $2 ; second = $1
	}
	s1 = first"_"second
	print s1, $3
    }
' $FILE |
tee f1 |
sort |
tee f2 |
awk '
BEGIN	{ FS = OFS = " " ; previous = "" ; line = "" ; first = "true"}
first == "true" { first = "false" ; previous = $1 ; line = $0 ; next }
$1 == previous	{ line = line " " $2 ; next }
		{ print line ; previous = $1 ; line = $0 }
END	{ print line }
' |
tee f3 |
awk '
NF <= 2	{ print $0, 0; next }
	{ print }
' |
tee f4 |
sed 's/_/ /'

exit 0

$ ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian 5.0.8 (lenny, workstation) 
bash GNU bash 3.2.39
awk GNU Awk 3.1.5
sed GNU sed version 4.1.5

-----
 Input data file data1:
A  A  200
A  B  100
A  C  90
B  B  203
B  A  101
B  C  87
C  C  300
C  A  91
C  B  86

-----
 Results:
A A 200 0
A B 100 101
A C 90 91
B B 203 0
B C 86 87
C C 300 0

$ ./s1

Environment: LC_ALL = POSIX, LANG = POSIX
(Versions displayed with local utility "version")
OSX 10.3.9
bash GNU bash 2.05b.0
grep - ( /usr/bin/grep, 29 Aug 2008 )
awk - ( /usr/bin/awk, 29 Aug 2008 )
sed - ( /usr/bin/sed, 29 Aug 2008 )

-----
 Input data file data1:
A  A  200
A  B  100
A  C  90
B  B  203
B  A  101
B  C  87
C  C  300
C  A  91
C  B  86

-----
 Results:
A A 200 0
A B 100 101
A C 90 91
B B 203 0
B C 86 87
C C 300 0