Move sql output data to one row

Question

I have SQL output which is in that form when get from the DB server:

 1 OI 021 141012 1321 0001242 4S 2 0080004 5 001 00014 6 000001 000000000000016973 6 0529540437 0000000000
2963526113
test 7 8 000000001 9

Before that I use tr "\t" " " | tr -s " " to remove unwanted blank spaces and tabs. Now wondering how to move the second and third row (or if there another rows) into the first row.

Expectation view for me was that one:

1 OI 021 141012 1321 0001242 4S 2 0080004 5 001 00014 6 000001 000000000000016973 6 0529540437 0000000000 2963526113 test 7 8 000000001 9

Simple tr `"\\n" " "` the the whole thing – Kalin Borisov Nov 13 '14 at 14:47 — Kalin Borisov, Nov 13 '14 at 14:47

score 1 · Accepted Answer · answered Nov 13 '14 at 14:42

1

A simple awk script would be

$ awk '{all=all $0} END{print all}' test
 1 OI 021 141012 1321 0001242 4S 2 0080004 5 001 00014 6 000001 000000000000016973 6 0529540437 00000000002963526113test 7 8 000000001 9

answered Nov 13 '14 at 14:42

nu11p01n73R

26,397
3
39
52

Move sql output data to one row

1 Answers1

Linked