topic file manipulation with scripts in Operating System - HP-UX

file manipulation with scripts

Theresa Patrie — Fri, 06 Aug 2004 11:52:19 GMT

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

Re: file manipulation with scripts

Victor Fridyev — Fri, 06 Aug 2004 12:07:59 GMT

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

Re: file manipulation with scripts

Theresa Patrie — Fri, 06 Aug 2004 12:24:35 GMT

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

Re: file manipulation with scripts

Muthukumar_5 — Sat, 07 Aug 2004 01:38:32 GMT

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

Re: file manipulation with scripts

Theresa Patrie — Wed, 11 Aug 2004 12:00:14 GMT

Same idea, different syntax. Thanks!