[SOLVED] format output bash

bishop2001 · 01-26-2016, 12:59 PM

Greetings
i have a file which contains the following

Something 01
average max min
123 215 0

Something 02
average max min
1 10 5

etc...

im hoping to change the output to look like:

Something 01
average
123
max
215
min
0

Something 02
average
1
max
10
min
5

help please
Thank again.

schneidz · 01-26-2016, 01:03 PM

what have you tried and where are you stuck. i would use awk.

grail · 01-26-2016, 01:38 PM

ditto for awk

bishop2001 · 01-26-2016, 02:23 PM

this works but its pretty lame. more compact way?

awk '{print $1}' file > 1;awk '{print $2}' file >> 1;awk '{print $3}' file >> 1

danielbmartin · 01-27-2016, 08:03 AM

This solution is written in a way which is intended to be instructive.
It could be done with fewer keystrokes but this is most readable.

With this InFile ...

Code:

 
Something 01
average max min
123 215 0

Something 02
average max min
1 10 5

Something 19
average max min
5 12 2

... this awk ...

Code:

awk '{n=NR%4;
      if (n==1)  print $0;
      if (n==2)  print $0;
      if (n==3)  split($0,a);
      if (n==0) {split($0,b);
        for (j=1;j<=3;j++)
          print a[j]"\n"b[j]}}' $InFile >$OutFile

... produced this OutFile ...

Code:

 
Something 01
average
123
max
215
min
0

Something 02
average
1
max
10
min
5

Something 19
average
5
max
12
min
2

Daniel B. Martin

grail · 01-27-2016, 10:27 AM

Quote:

Originally Posted by bishop2001

this works but its pretty lame. more compact way?

awk '{print $1}' file > 1;awk '{print $2}' file >> 1;awk '{print $3}' file >> 1

How does this deliver what you want??
Here is what I get running your suggestion:

Code:

$ awk '{print $1}' file > 1;awk '{print $2}' file >> 1;awk '{print $3}' file >> 1
$ cat 1
Something
average
123

Something
average
1

Something
average
5
01
max
215

02
max
10

19
max
12

min
0


min
5


min
2

The above to me does not look anything like your originally requested output.

So before I can deliver a solution I need to know which output you are after?

Also, are you really looking to make a file called '1'?