Shell Programming and Scripting

Hi,

I need to make a file3 from the comparision of file1 and file2...

file1

x1,x2,x3,x4

file2

y1,y2,y3,y4

if (x2=y3) then file3

x1,x3,y1,y3,y4


Thanks

what is the logic ,plz specify clearly..
I am not getting it ...!!

Also, do these files 1 and 2 have the same record or not? Does it need to be compare line by line ( are they sorted or does it require soting)

Thanks for your reply. I am sorry for not explaining my question throughly....

Both files are not same. both files will have different records. Only one column in both the files will be same. All the rows in both the files will be unique. Take an example:
File 1:
Department, Date, Place, City
File2:
X1, X2, Place, X3
I need to get only those rows from file 1 where 'Place' in file 2 equal to 'Place' in file1 and then make the file 3 with the columns of file1 and file2 as follows:
File3:
Department, Date, X1,X2,X3

Is it possible? I am trying to explain more:

File1:
51999900,34.55,2/1/2009,"XYZ"
File2:
51999900,EUROPE AREA 1
now compare on column1 of file1 with column1 of file2...if matches then put the 2nd column value of file2 in the end of 1st file....
file3:
51999900,34.55,2/1/2009,"XYZ",EUROPE AREA 1
if not matches then write that row of file1 to a file4

Not sure if you are looking for this

Code:

awk -F "," 'NR==FNR{a[$1]=$2;next}{
if ($1 in a) print $0,a[$1] > "file3"
else print $0 > "file4"
}' OFS="," file2 file1

cheers,
Devaraj Takhellambam

Thanks for your suggestion. I get the following error......Please suggest...

syntax error The source line is 1.
The error context is
NR==FNR{a[$1]=$2;next}{if ($1 in a) print $0,a[$1] > "file3" >>> else <<< print $0 > "file4"}
awk: The statement cannot be correctly parsed.
The source line is 1.