Compare two file & output

Shell Programming and Scripting
1

Hi every body

i have a problem need help urgently

file 1 (approx 200K entries)

aaaaa
bbbb
cccccc
dddd
ffff

file 2 (approx 2 million entries)

aaaaa,1,ee,44,5t,6y,
bbbb,3,ff,66,5u,8r,
cccccc, .....
dddd, .....
eeeeee, .....
ffff, ......
ggg, .......

i wanna compare two file
if entry in file 1 exist in file 2 , output show full row content from file 2.

result =

aaaaa,1,ee,44,5t,6y,
bbbb,3,ff,66,5u,8r,
cccccc, .....
dddd, .....
ffff, ......

++++++++++++++++++++++++++++++++++++++++++++

Thanks in advance

The_Archer

2

Assuming an entry in file1 is to be matched against the first field in file2:

nawk -F, -v OFS=',' 'FNR==NR {f1[$1]; next} $1 in f1' file1 file2
3 
awk -F, ' { if (FILENAME=="file1") {arr[$0]=1}
          if(FILENAME=="file2" )
           {
                for(i=1; i<=NF; i++) { if ($i in arr) {print $0; next}}
           }
          ' file1 file2
4

#!/bin/sh
for name in `cat file1`
do
grep $name file2 >> file_results.txt
done

5 
fgrep -f file1 file2
6

THANKS A LOT
You Guys Made my day

one thing to ask

which process is fast
as my file 2 has 2 million rows
& in each row approx 200 comma seperated field

i will run it on V890 with 16 G.

just for information
i have tried grep option before but it was tooooooo slow even on V890

What you Guys suggest