Shell Programming and Scripting

Hi All,

I have two files as given below:

fileA
1234|aaaaa|vvvv
2222|bbbbbb|cbxxbjh
3333|cccc|jhjhj

fileB
3434|bbbcc|cbxxbjh
1234|cat|bullet
3333|cccc|jhjhj

I need a script that reads the first column from fileA (i.e 1234) and searches in fileB in the first parameter(i.e first column), if match found ( for example 1234 - line1 in fileA and 1234 - line 2 in fileB), then append the rest of the row in file and write to a new file

Example
Get first parameter in first row in fileA = 1234
search for the line with first parameter as 1234 in fileB.We get line 2.
write 1234|aaaaa|vvvv|cat|bullet to fileC.

Thanks in advance
JS

Post what have you tried so far and where exactly are you stuck?

using awk i can get the first parameter from each line in fileA.
But piping it to fileB for search is where am really stuck

Search the forum for NR==FNR

I have been trying with this command
awk 'NR==FNR{_[NR]=$0;next;}{$1=_[FNR];print}' file1 file2

but i donot know how exactly this works. And it is printing only fileA rows. i don know where to tune it.

I have searched the forum, still i dont understand where to make the necessary change to meet my need.

I have got n number of files to do the processig in this way.
Can someone plese help

Please don't bump up questions, read the rules.
Try this:

Code:

awk -F"|" 'NR==FNR{a[$1]=$2"|"$3;next}
a[$1]{print $0"|"a[$1];next}1' fileB fileA

Regards