Can Two input files be processed at awk..?

[Awkunix]

Hi,

I have situation where 2 data files, File A and File B. I need to read record from File A second column and replace third column of File B in sequence order.

File A File B

1 ab 1 a xx
2 ac 2 a yy
3 ad 3 a zz
4 ae 4 a ww

Expected out put is

File B

1 a ab
2 a ac
3 a ad
4 a ae


Can awk accept 2 input files as arguments ? and allow to change $3 in FileB ?

Any help is highly appreciated.

Thanks in Advance

VK

 

[vgersh99]

something like that:
nawk -f subst.awk fileB
OR
nawk -v fn="path2fileA" -f subst.awk path2fileB
#------------------ subst.awk
BEGIN {
if (!fn) fn = "fileA"
lineA=0
while((getline < fn) > 0)
arr[++lineA] = $0
}
{
if ( NR in arr) {
split(arr[NR], arrSplit, FS);
$NF=arrSplit[2];
}

print;
}


vlad
+----------------------------+
| #include<disclaimer.h> |
+----------------------------+

 

[Awkunix]

Thank you Vgersh99. Its work fine and your code gave me lot of idea in exploring other options with array. I am novice in awk programming and trying to understand awk’s powerfulness. Thanks again for your help.

VK