UNIX for Dummies Questions & Answers

Hi all!

my first post here, so mods -- if this should ideally be in the scripts section, please move there. Thanks!

I have data in the following format:

Code:

key1:value1 key2:value2 key3:value3
A
B
C
D
key1:value4 key2:value5 key3:value6
A1
B1
key1: ...

and so on

I want an output of the following form

Code:

value3, A B C D
value6, A1 B1

and so on [basically, get value of key3 and rearrange the data on one line with a space separating each "word".

Can someone tell me how to do this, and show it with a script?

Thank you.

Try:

Code:

awk '/key3/{split($3,a,":");printf "\n"a[2]", "}!/key3/{printf $0" "}END{printf "\n"}' file

Thanks, bartus11! Worked perfectly