I have a stdout :

jh888636 4533 cklsls 55885
sp838922 7373 ksshhs 77321
dp828273 8722 kiwjkk 72661

I have a static file to lookup:

"ah768889"|"Aron Hease"|"Louis Jid"|"99949"
"jh888636"|"John Holmes"|"Peter King"|"60036"
"sp838922"|"Steven Parn"|"Jay Walker"|"60004"
"dp828273"|"David Pim"|"Kate Jast"|"89488"

Now, my goal is to match column 1 from stdout to column 1 in the static file and extract/print column2/column4 etc

Exampled Desired output:

John Holmes (60036) 4533 cklsls 55885
Steven Parn (60004) 7373 ksshhs 77321
David Pim   (89488)  8722 kiwjkk 72661