file manipulation with scripts

[Theresa Patrie]

Hi All...
I have a file that looks like this:

User: frencht
License: panth.5.0
License: panth_des.5.0
User: miedicr
License: panth_des.5.0
User: patriet
License: panth.5.0
License: panth_des.5.0
User: gormanl
License: panth.5.0
License: panth_des.5.0
User: bozzad
License: panth_des.5.0

It is a username followed by any number of license lines for licenses that are checked out. How can I change the format of this file so that it looks like this:

User: frencht panth.5.0 panth_des.5.0
User: miedicr panth_des.5.0
User: patriet panth.5.0 panth_des.5.0
User: gormanl panth.5.0 panth_des.5.0
User: bozzad panth_des.5.0

I am sure there is a relatively simple way, but I've been messing around with awk and sed and haven't quite got it. Please help!
Thanks,
Theresa

[Victor Fridyev · Accepted solution]

Hi,
This should work:

awk -F: '/User/ {printf("\nUser:%s",$2);continue}
{printf("%s ",$2)}
END {print ""}' FILE | awk 'NR>1 {print}'

If empty string in the output is not a problem, remove second awk
HTH

[Theresa Patrie]

Thank You Victor...it absolutely does work...perfectly!

[Muthukumar_5]

We can do it simply as,

awk -F ":" '{ if ( $1 == "User" ) printf("\n%s",$2)
if ( $1 == "License" ) printf("%s",$2) } END { print ("\n") }' filename

frencht panth.5.0 panth_des.5.0
miedicr panth_des.5.0
patriet panth.5.0 panth_des.5.0
gormanl panth.5.0 panth_des.5.0
bozzad panth_des.5.0

- muthu

[Theresa Patrie]

Same idea, different syntax. Thanks!