Revisions to awk - cross match columns across another file and replace fields

deleted 13 characters in body; edited tags

Source Link

edited Apr 22, 2018 at 7:33

41.9k
17
75
117

I have a stdout :

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

I have aand 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 Desireddesired output:

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

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

I have a stdout:

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

and 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

deleted 4 characters in body

Source Link

edited Apr 22, 2018 at 6:41

Dablu Dev

1
1

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/column3/column5column4 etc

Exampled Desired output:

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

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/column3/column5

Exampled Desired output:

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

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

improved code formatting

Source Link

edited Apr 22, 2018 at 6:33

Inian

13.1k
2
42
55

I have a stdout :

[code] jh888636 4533 cklsls 55885 sp838922 7373 ksshhs 77321 dp828273 8722 kiwjkk 72661 [/code]

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/column3/column5

Exampled Desired output:

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

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

I have a stdout :

[code] jh888636 4533 cklsls 55885 sp838922 7373 ksshhs 77321 dp828273 8722 kiwjkk 72661 [/code]

I have a static file to lookup:

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

Exampled Desired output:

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

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/column3/column5

Exampled Desired output:

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

Source Link

asked Apr 22, 2018 at 6:30

Dablu Dev

1
1

Loading

Stack Exchange Network

Return to Question