UNIX for Dummies Questions & Answers

I am using SCO Unix, and inside have forte software which is similar with MySQL to store our product data. I am trying to print out serial number.

I use the following code and get result is like
Q>PRINT SERNUM WHERE ORDNUM=720385 USEKEY OE_ORDSER_KB
'T'erminal, 'P'rinter, or 'F'ile? T
Serial Number
----------------
P6GK1VXF
P6GKT0RF
P6GKTA3F
P6GKVXUF
P6GKVY2F
P6GKW21F
P6GKW2GF
P6GKYH4F
P6GKYP5F
P6GKYPKF
P6GKYPRF
P6GKYS4F
P6GKYSDF
P6GKYSNF
P6GKYWBF
P6GKYWPF
P6GKYYDF
P6GKYYPF
P6GKYZTF
P6GKZ17F
P6GKZ18F


This is right, but I want it horizontally to print out, one by one. How can I do? Who knows about this software?

Select File instead of terminal.
Then use tr on the output file you just made

Code:

tr -s '\n' ' ' < myfile > newfile

newfile will have everything one one line.

If you want to ignore the first 2 lines you can use sed with tr:

Code:

sed -n '3,$p' file | tr '\n' ' ' > newfile

or with awk:

Code:

awk 'NR > 2{printf("%s ", $0)}' file > newfile