Search Results

Then change the field separator value before reading each file:
awk 'FNR==NR{A[$1]=$2;next} $1 in A{$2=A[$1]} 1' FS='x' Input_file2 FS='y' OFS='y' Input_file1
where x is the field separator in...

Hello Prabal Ghura,

So let's say your 1 file named Input_file2 has delimiter as ; and Input_file1 has delimiter as ,, we could set it for both of them. This is just an example, you could try to...

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

Hello Prabal Ghura,

Could you please try following.

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.
...