UNIX for Dummies Questions & Answers

Thank you.

I'm working on a HP-UX system..The man page of join says this at the end.

Code:

STANDARDS CONFORMANCE
      join: SVID2, SVID3, XPG2, XPG3, XPG4, POSIX.2

and like you said, maybe this POSIX.2 is older than 1997

I wrote this join function with awk and seems to be working. Once confirmed, i will paste it here..

---------- Post updated at 01:55 PM ---------- Previous update was at 01:30 PM ----------

Found a small work around with awk:

The input files are more like this now: (in the first file, I cannot always know how many fields are present..and in second file,only the last field matters. ***So,Mo,Tu are just example field names )

Code:

cat xxx yyy
item,So,Mo,Tu
aaa,1,1,1
bbb,1,1,4
ccc,1,1,0
ddd,1,1,1
 
item,We
aaa,1
bbb,0
eee,1
fff,2

Code:

awk -F\, '{OFS=","} 
NR==FNR { A[$1]=$0 ; b[$1]="0" ; fields1=NF-1; next }
($1) in A { b[$1]=$NF } 
!(($1) in A ){
A[$1]=$1
filler="0"
for (i = 1; i < fields1; i++) { filler=filler",0" }
b[$1]=filler","$NF
}
END { for (i in A) print A[i],b[i]}' xxx yyy |sort

output:

Code:

aaa,1,1,1,1
bbb,1,1,4,0
ccc,1,1,0,0
ddd,1,1,1,0
eee,0,0,0,1
fff,0,0,0,2
item,So,Mo,Tu,We

now,i will deal with the header

Does it look ok?