Combining Two Files

Shell Programming and Scripting
1

I have two files which contain data from two different transactions in the same format:

<Name> - <Count>

My goal is to end up with data in this format after combining the two:

<Name> - <Count1> - <Count2>

Is this possible to do with awk, or is there something better?

Thanks...

2 
BEGIN { FS = " - " }
{ a[$1] = a[$1] FS $2 }
END {
  for (key in a)
    print key a[key]
}
3

I'm not sure about the above awk script, but try the join command - you have to sort the files first.

4

cat file1>>file2

Works like a charm on Ksh. No sorting required.