I have two files. File A and File B.

File A has two fields separated by comma

352020252365988, 652020100572356
546876543215667, 652065465654686
...

File B has many Fields separate by spaces

Date Name 352020252365988 Reference
Date2 Name2 546876543215667 Reference


I want to search for a match of Field 1 of file A in file 2. If there is a match print the line that contains the match, and append field 2 of File A at the end of each matched line.

so to have

Date

This code works for me

#!/bin/sh

while read line
do
  lookup=`echo "$line" | awk -vFS=',' '{print $1}'`
  field=`echo "$line" | awk -vFS=',' '{print $2}' | sed 's/^ //'`
  match=`grep "\<$lookup\>" file_b`
  if [ "$?" -eq "0" ]; then
    echo "$match" | while read record
    do
      echo "$record $field"
    done
  fi
done < file_a

If the match is on the 3rd field of the 2nd file, then you can try this awk...

BEGIN {
   FS=","
   while(getline<xref) arr[$1]=$2
   FS=" "
}
$3 in arr {
   print $0, arr[$3] 
}

Thanx, both these scripts have worked!

I prefer the last one since I get to name files at the command prompt.

gurus u are, u guys!

___
Axl

Just FYI, if you change the code I posted thusly

#!/bin/sh

while read line
do
  lookup=`echo "$line" | awk -vFS=',' '{print $1}'`
  field=`echo "$line" | awk -vFS=',' '{print $2}' | sed 's/^ //'`
  match=`grep "\<$lookup\>" ${2}`
  if [ "$?" -eq "0" ]; then
    echo "$match" | while read record
    do
      echo "$record $field"
    done
  fi
done < ${1}