UNIX for Advanced & Expert Users

Hi RudiC, The code which you gave is worked for my case. Thank U.
however i need to impelement the if as i mentioend in earlier post.

Code:

 if ( ( $2 ~ x[1] ) and ( $5 ~ x[2] ) )  or ( ( $2 ~ x[2] ) and ( $5 ~ x[1] ) ) { print $0 > "yes.txt"; } else { print $0 >

Please help on this

Above doesn't work. Neither awk nor shell have "and" or "or". Replace by "&&" and "||" and try again. Why do you "need to impelement the if" ? Was your specification not describing the whole picture?

RudiC gave you code that you say works. Now you want us to redo that working code to use code that is incomplete and contains many syntax errors.

WHY do you NEED to change what RudiC suggested?

Is this a homework assignment?

You implied earlier that you had code using nested loops that gives you the correct results but is too slow to work on your actual data. Please show us your working code!

And, please clarify what you mean by match. Do you mean the two strings being matched are equal? Or, do you mean that a string in file1 matches a string in file2 if the string in file1 is contained in the string in file2?

Thank you all for your valuable suggestions.. Some how the issue got resolved except the below one..

Now I need to print first column from file 2 and columns 1,2,4 from file 1 when ever I grt a match in below code...

Code:

awk     'NR==FNR                {a[$1,$2]; next}
         ($2 SUBSEP $5 in a)    {print a[$1], $1, $2,$4 > "yes.txt"; next}
                                {print $0 > "no.txt" }
        ' file2 file1

I am not able to get the result as expected. Please help

As per your specification, $1 in file2 equals $2 in file1. So you could print $2, $1, $2, $4 in your script.

Yes rudic..
You are correct.. I want to print first column from file 2 and some columns from file 1 when it matches...please help.