Hi,I have 2 files master.txt & reference.txt as shown below & i require o/p as mentioned in file 3 using awk but content is not replacing properlymaster.txt:
919814047423728,Idea,PUN2372,MTS,AP25E4,Aircel,AP250A,Idea,AP2630,Airtel,PB919014002000,RCOM,AP919700099155,Aircel,APreference.txt2630,919700099155,123728,919700099155,225E4,250A,3919014002E40,919814047423728,10o/p:Airtel PB,Aircel AP,19198140474MTS AP,Aircel AP,2Aircel AP,Idea AP,3919014002E40,9198140474MTS AP
I want to match the exact length in reference.txt for replacement through master.txt & if it is not found then refernce file should print as it is. Please helpi have written the following sample code:
awk -F, 'NR==FNR {rep[$1]=$2" "$3; next}{ for (r in rep) gsub(r,rep[r],$0); print $0}' master.txt reference.txt