Search for pattern in another file and output result in file3

[varajan]

Can somebody help with the following ?

Input files

File 1 format
field1,field2 --> Both are text
....

File 2 format
fields1 --> text

Output File

File 3:
field1,field2,field3 --> Both are text

Requirement:
for each line in file1, search for file1.field1 and file1.field2 in file2.field1
AND
if match found in file2, then append the following details to file3
file1.field1, file1.field2, file2.field1


for each row in table1, I need to search for table1.field1 and table1.field2 in table2.field1, and if the search is successful then in table 3, I need to populate the following:
table3.field1 = table1.field1
table3.field2 = table1.field2
table3.field3 = table1.field3

 

[tchatzi]

Can you show us a live sample of file1 and file2
and how would you like file3 to look like.
Are the fields comma seperated?


``The wise man doesn't give the right answers,
he poses the right questions.''
TIMTOWTDI

 

[KevinADC]

Sounds like school work? Students are not supposed to post school assignments on this forum.