Help with joining two files - Shell Programming and Scripting

aigles · #2 (**permalink**) 09-27-2006

Try an adapt the following awk program :

Code:

BEGIN {
   FS = OFS = ",";
}
FNR == NR {
   Descr[$1,$2] = $3;
   next;
}
{
   if (($3,$4) in Descr) 
      print $0,Descr[$3,$4];
   else
      print $0,"Unknown Account";
}

Execute the program with the command :

Code:

awk -f program.awk File_1 File_2

The account description will be append to the end of each line of File_2.

Jean-Pierre.