Shell Programming and Scripting

I have two files with multiple columns separated by commas.

I want to search one column from the first file in the second file;
If there is a matching, will append that matched row to the first file. Let me show an example... (unique values in the search column)
First file
aa,reg1,bb,cc,dd,ff
xx,reg2,dfd,dfc,dfdas
cv,reg3,dfd,dfc,erwqe
df,xcv.df,cv,'',;l

I would like to search the second column of the first file with the fifth column of the second file.
Second file
111,334,77,888,reg7
adf,5435,7652,425,reg3
dfa,1,23,N,
adf,2,56,76,pop

The result should be
aa,reg1,bb,cc,dd,ff
xx,reg2,dfd,dfc,dfdas
cv,reg3,dfd,dfc,erwqe,adf,5435,7652,425
df,xcv.df,cv,'',;l


How can I do this please?

Thank you very much

If sorting the files is not too much of a burden, look at the join command.

how to sort the file in this case? which column is to be sorted?
Thanks

Read the manual page for the join command, it explains what needs to be sorted and provides some examples.

Code:

awk 'NR == FNR {
t = $5
sub(/,[^,]*$/,"")
x[t] = $0
next
}
$2 in x {
$0 = $0FS x[$2]
}1' FS=, file2 file1

Use nawk or /usr/xpg4/bin/awk on Solaris.

you can use
sort -t, +1 -2d first file > new1
sort -t, +4 -5d second file > new2
join -1 2 -2 5 -t, -o 1.1 2.5 1.2 1.3 1.4 1.5 new1 new2 | sort -t, +1 -2 > new3

Here the -t, is used becasue the "," is used as delimiter.
Njoy

This should work but u can find a better one

cat file1 | while read line
do
var=`echo $line | cut -d"," -f2`
cat file2 | while read value
do
val=`echo $value | cut -d"," -f5`
val4=`echo $value | cut -d"," -f4`
val3=`echo $value | cut -d"," -f3`
val2=`echo $value | cut -d"," -f2`
val1=`echo $value | cut -d"," -f1`
if [[ $var == $val ]]
then
line=`echo $line,$val1,$val2,$val3,$val4`
fi
done
echo $line
done

Regards,
aajan