[SOLVED] AWK

czezz · 12-28-2010, 07:24 AM

I want to do a transpose.
On the input file I have just 1 column. What I need is to put values from that column into a rows - each 8 columnes.

What I can do wno is to put all values into a 1 row... (i need to have many rows by 8 columns)

Code:

nawk '$1=$1' RS= input.file

Here is an input.file:

Code:

10004.00,
106473388.00,
1442167619.00,
192.80,
14.71,
318145.44,
941276.69,
311.00,
10037.00,
218609.00,
232698.00,
138.33,
2.95,
104.00,
1014763.31,
7.00,
10006.00,
510197111.00,
5177395202.00,
179.16,
15.42,
189461.72,
967962.06,
341.00,
11491.00,
702082782.00,
17808287130.00,
253.96,
18.02,
162678.22,
2868964.25,
81.00,
10004.00,
106473388.00,
1442167619.00,
192.80,
14.71,
318145.44,
941276.69,
311.00,

This is what I need to get:

Code:

10004.00,106473388.00,1442167619.00,192.80,14.71,318145.44,941276.69,311.00,
10037.00,218609.00,232698.00,138.33,2.95,104.00,1014763.31,7.00,
10006.00,510197111.00,5177395202.00,179.16,15.42,189461.72,967962.06,341.00,
11491.00,702082782.00,17808287130.00,253.96,18.02,162678.22,2868964.25,81.00,
10004.00,106473388.00,1442167619.00,192.80,14.71,318145.44,941276.69,311.00,

Any suggestions how to make it ?

colucix · 12-28-2010, 07:31 AM

Code:

awk '{printf "%s", $0}!(NR % 8){printf "\n"}' file

czezz · 12-28-2010, 08:08 AM

Thank you very much!
In the mean time I tryed this:

Code:

i=0;
cat file |while read row;
   do echo -n "$row";
   i=`expr $i + 1`;
      if [ "$i" == "8" ]; then 
         echo "";i=0;
      fi;
   done

...but it works like 100 times slower than your method.
AWK seems to be really powerful tool

This is how I understand this code:

Code:

'{printf "%s", $0}! - print each string %s from each line;
(NR % 8){printf "\n"}' set the Number of Rows as 8 then put \n [ENTER]

Is this make sense ?

grail · 12-28-2010, 08:27 AM

Code:

awk '1;!(NR%8){print "\n"}' ORS= file

Same, same but different

colucix · 12-28-2010, 08:36 AM

Quote:

Originally Posted by czezz

Thank you very much!

You're welcome!

Quote:

Originally Posted by czezz

Code:

'{printf "%s", $0}! - print each string %s from each line;
(NR % 8){printf "\n"}' set the Number of Rows as 8 then put \n [ENTER]

Is this make sense ?

Not really. The statement

Code:

{printf "%s", $0}

prints out the whole line (record in awk) without the newline at the end. The expression

Code:

!(NR % 8)

negates (!) the remainder of the division between the current record number (NR) and 8. Take in mind that in awk any numeric value different from zero or any string different from the null string is evaluated as true. We need to print a newline whereas the remainder is 0 (that is every 8 records) so that the expression must be evaluated as true when it is 0, as false for any other value. This is the opposite of what awk does, hence the negation.