Shell Programming and Scripting

Name,year,organization
Jim,2007,Org1
Bob,1999,Org3
Chris,2001,Org2

DocumentName,DocumentTitle,organization,year
Test1,Test1,Org1,2007
Test2,Test2,Org2,2008
Test3,Test3,Org3,2009

while readline
 do
    if test $i -ge 1;
    then
        echo "$line" awk '{print $1","$2}' >> File3 

        now use $2 to search File2 for a match
        if found print the value of $1 in File2 to File3    fi
 done < $File1

Jim,2007,Test1

awk 'BEGIN{FS=OFS=","}
FNR==NR{arr[$2]=$1;next}
$4 in arr{print $4,arr[$4],$1}
' file1 file2