Shell Programming and Scripting

I want to merge files as described below:

File 1

Code:

a;1;abc
b;2;def
c;3;xyz
d;4;pqr
e;5;mno

File 2

Code:

b;41
d;77

output

Code:

a;1;abc
b;41;def
c;3;xyz
d;77;pqr
e;5;mno

Please suggest how to do this.

Moderator's Comments:

Please use CODE tags when displaying sample input, sample output, and code segments.

Is this a homework assignment? Homework and coursework questions can only be posted in the Homework & Coursework Questions forum as specified in the special homework rules.

Please review the rules, which you agreed to when you registered, if you have not already done so.

If this is not a homework item, please explain how this code will be used and tell us what operating system and shell you're using.

No this is not a home work assignment we use flat files to load our user database from multiple locations. Every record contains multiple fields for a user. For a specific set of users, the value coming in File is wrong. For all such users we get another correction file. So for such users we just want to overwrite one field value from correction file before loading it into our database.

32690 pts/2 00:00:00 ksh

Hello Prabal Ghura,

Could you please try following.

Code:

awk -F";" FNR==NR'{A[$1]=$0;next} ($1 in A){print A[$1] FS $NF;next} {print}' Input_file2  Input_file1

Output will be as follows.

Code:

a;1;abc
b;41;def
c;3;xyz
d;77;pqr
e;5;mno

Thanks,
R. Singh

Any attempts/ideas/thoughts from your side?

Howsoever, try also

Code:

awk 'FNR == NR {T[$1] = $2; next} $1 in T {$2 = T[$1]}  1' FS=";" OFS=";" file2 file1

Thanks RavinderSingh13, you saved my day