topic Re: Reformatting text in Operating System - HP-UX

Reformatting text

Ciro_gft — Mon, 22 Jun 2009 06:50:23 GMT

Hi all,

I received the following output after an SQL script:

TradeId CommonRef MirrorId TermAssignStatus Book
P/S Customer Currency Curve Effective Date
Maturity Date Notional Amount Product Type Rate
Trade Status Sec Amount Trade Date Trader ParentId
Last Update

That's actually an excerpt, there are 22k entries with this format. Instead of those 8 columns what I'd need a single line with every entry being it's own column. I've attached a text file with the original format and how I'd like it reformatted.

I've been trying awk but I can't seem to find the way to do it, can someone give me a tip on this?

Thanks and Regards,

Ciro

Re: Reformatting text

Ciro_gft — Mon, 22 Jun 2009 06:52:12 GMT

Sprry I didn't include the file, here it is.

Re: Reformatting text

Suraj K Sankari — Mon, 22 Jun 2009 07:21:49 GMT

Hi,
suppose your data stored on a file "d"
In the command prompt write this line,

#awk '{ printf "%s", $0 }'
if you want your output into another file then do like this
#awk '{ printf "%s", $0 }'outputfile

Suraj

Re: Reformatting text

Ciro_gft — Mon, 22 Jun 2009 08:29:57 GMT

Hi Suraj,

Thanks for your help.

Re: Reformatting text

Dennis Handly — Mon, 22 Jun 2009 09:35:59 GMT

It appears you want to combine 5 lines into one, for 22 K entries?
awk '{
getline L2
getline L3
getline L4
getline L5
print $0, L2, L3, L4, L5 }' file

Re: Reformatting text

Ciro_gft — Mon, 22 Jun 2009 09:48:05 GMT

Hi Dennis,

Yes that's what I needed, thanks very much.

Re: Reformatting text

James R. Ferguson — Mon, 22 Jun 2009 11:43:38 GMT

Hi Ciro:

To combine multiple lines into one you can use 'paste'.

# paste -d" " - - - - - < myfile

See the manpages for more information.

Regards!

...JRF...

Re: Reformatting text

OldSchool — Mon, 22 Jun 2009 15:03:55 GMT

from JRF: "# paste -d" " - - - - - < myfile"

thats an application of paste / redirection I'd never encountered before. nifty!