Hi All,

Seeking for your assistance on how to bash 2 files and then print if the condition met.

Ex.
file1.txt:

Code:

Field1   Field2     Field 3        Field 4
usa      <blank>  <blank>     INDIA

file2.txt:

Code:

Field1     Field2     Field 3        Field 4
canada    jap        INDIA         utah

Condition
If Field 4 of file1.txt = Field 3 of file2.txt, the value of Field 1(canada) and Field 2(jap) of file2.txt will be put on Field 2 and Field 3 of file1.txt

Expected Output in file1.txt:

Code:

Field1   Field2     Field 3        Field 4
usa      canada    jap             INDIA

I used the code below:

Code:

awk 'NR==FNR{a[$1];next}$1 in a{print $1, $2}' file1.txt file2.txt

it will print the common string but i don't know how to put the output in file1.txt

Thanks,

Moderator's Comments:

Using CODE tags correctly doesn't mean putting everything but "Thanks," in CODE tags. Please put CODE tags around sample input, sample output, and code segments.