Shell Programming and Scripting

Hey,

Quick query.

If I have 2 Files - File1 (2M Lines) & File2 (5K Lines) & I want to find & replace the 5K Lines from File2 in File1 - What's the fastest way?

I'm currently doing it using sed which takes ages.

File1 (2M Lines)

Code:

A1;B1;C1;D1;E1
A2;B2;C2;D2;E2
A3;B3;C3;D3;E3

File 2 (5K Lines)

Code:

A2;B2;F2:G2
A4;B4;F4;G4

Pick Line by Line from File2, Find in File1, then Delete that Line in File1 & add corresponding Line from File2 to File1

Merged & Replaced Output (2M Lines)

Code:

A1;B1;C1;D1;E1
A2;B2;F2:G2
A3;B3;C3;D3;E3

---------- Post updated at 03:03 PM ---------- Previous update was at 02:57 PM ----------

I couldn't go with join since it checks only 1 column. I need to check First 2 Fields from File2 in File1.