By using AWK can I convert matrice shaped data to a row ?

Shell Programming and Scripting
1

Hello,

I have output in the matrice form , for example:

1 2 3 4
a b c d
jim joe sue tom

how can I convert this line-column data into a row as follows

1 2 3 4 a b c d jim joe sue tom

thank you

2 
tr '\n' ' ' < infile

awk '$1=$1' RS= infile
3

Try this,

paste -s inputfile
4 
xargs < infile
5

thank you all, I am trying the codes

6 
$ ruby -00 -ne 'puts $_.split.join(" ")' file
1 2 3 4 a b c d jim joe sue tom
7

Pravin, Scrutinizer and Kurumi thank you very much... Is it possible to convert it to a column data like:

1
2
3
4
a
b
.
.
.

best regards

8 
$ ruby  -ane '$F.each{|x| puts x}' file
1 Like
9 
xargs -n1 < infile

awk '$1=$1' OFS="\n" infile

tr '[ \t]' '[\n*]' < infile
1 Like
10

great codes... all of them works well... thank you...

---------- Post updated at 03:10 PM ---------- Previous update was at 02:59 PM ----------

awk '$1=$1' OFS="\n" infile

I have hundreds of lines and columns. It is seen that the fastest command is above.

thank you all

11 
 tr ' ' '\n' < inputfile
12

suppose that we have column data
1
2
3
4
5
6
.
.
.
how can I generate a new column data by summing the elements of 3 by 3 that gives a result as follows

6
15
.
.
.

THANK YOU

13

something like this:

awk 'NR%3==0 { sum = sum + $0 ; print sum ; sum = 0 ; next } { sum = sum + $0 }' file_name
14

Assuming that the number of lines in file is a multiple of 3:

sed 'N;N;y/\n/+/' file | bc

paste -d+ - - - < file | bc

For a more general case (the final number will be the sum of 1 or 2 lines if that's all that remains):

paste -d+ - - - < file | sed '$s/++*$//' | bc
15

Dear Panyam and alister, both the codes work perfect.

thank you for your time