Reformatting text

[Ciro_gft]

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

[Ciro_gft]

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

[Suraj K Sankari]

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

[Ciro_gft]

Hi Suraj,

Thanks for your help.

[Dennis Handly · Accepted solution]

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

[Ciro_gft]

Hi Dennis,


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

[James R. Ferguson]

Hi Ciro:

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

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

See the manpages for more information.

Regards!

...JRF...

[OldSchool]

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

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