Add a result of another script into a table with awk

Question

I have an awk script (let's call it my_script) which gives output as one column, like this:

DD
EE
AA
CC
BB

I also have another table:

I want to add it to my existing table as the last column:

C1 123 DD
C3 222 EE
C5 175 AA
C4 318 CC
C8 299 BB

I tried the following script but it didn't work:

awk '{print $0, $3=myscript}' file.txt

Get the book Effective AWK Programming, 5th Edition, by Arnold Robbins to start learning about awk. — Ed Morton, Jan 02 '23 at 23:34

score 2 · Accepted Answer · answered Jan 02 '23 at 23:02

2

You can use paste:

my_script |
paste -d ' ' table.txt -

answered Jan 02 '23 at 23:02

Fravadona

Thank you, how can I paste more than one script? – Dr. Heinz Doofenshmirtz PhD Jan 02 '23 at 23:07
1

@Dr.HeinzDoofenshmirtzPhD for "pasting" the output of multiple scripts then you'll need to use bash processes substitutions, for example `paste -d ' ' <(my_script1) <(my_script2) <(my_script3)` – Fravadona Jan 02 '23 at 23:30
1

There are, of course, alternatives. The better response IMHO would be - ask a new question with it's own [mcve]. – Ed Morton Jan 03 '23 at 12:24

1 Answers1