How will you change the 5th column in the data file with the value in the second column in the error_correction.txt file.
You have to match an extra variable, column 3 of the error_correction file with column 6 of the data.txt file.
data.txt:
vgr,bugatti veron,,3.5,Maybe,6,.......,ax2,....
vgr,lamborgini,,3.5,nos,6,.......,gd2....
abc,bugatti veron,,3.5,nos,,6,.......,as3.......
.
.
.
.
error_correction.txt:
VenoM,Venom,am1
Venom,VENOM,ax2
nos,NOS,ba1
nos,N2O,gd2
nos,n2o,as3
..
.
.
.
How would you do this using awk?