https://community.hpe.com/t5/operating-system-hp-ux/script-needed/m-p/5640723#M638063 <P>awk '</P><P>BEGIN&nbsp; { OFS=":" }</P><P>{</P><P>host=$0</P><P>getline port</P><P>getline app</P><P>print host, app, "PROD", port</P><P>} ' file</P> Sun, 29 Apr 2012 20:09:17 GMT Dennis Handly 2012-04-29T20:09:17Z https://community.hpe.com/t5/operating-system-hp-ux/script-needed/m-p/5640501#M638062 <P>Hi All,</P><P>&nbsp;</P><P>Have a file which has a list of host, app &amp; port -</P><P>&nbsp;</P><P>host1</P><P>port1</P><P>app1</P><P>host2</P><P>port2</P><P>app2</P><P>host1</P><P>app2</P><P>port2</P><P>...</P><P>...</P><P>&nbsp;</P><P>Need output in the following format-</P><P>&nbsp;</P><P>host1:app1:PROD:port1</P><P>host2:app2:PROD:port2</P><P>&nbsp;</P><P>where PROD is fixed text in it.</P><P>&nbsp;</P><P>Thanks,</P><P>Allan.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 29 Apr 2012 08:05:06 GMT https://community.hpe.com/t5/operating-system-hp-ux/script-needed/m-p/5640501#M638062 allanm77 2012-04-29T08:05:06Z https://community.hpe.com/t5/operating-system-hp-ux/script-needed/m-p/5640723#M638063 <P>awk '</P><P>BEGIN&nbsp; { OFS=":" }</P><P>{</P><P>host=$0</P><P>getline port</P><P>getline app</P><P>print host, app, "PROD", port</P><P>} ' file</P> Sun, 29 Apr 2012 20:09:17 GMT https://community.hpe.com/t5/operating-system-hp-ux/script-needed/m-p/5640723#M638063 Dennis Handly 2012-04-29T20:09:17Z