Shell Programming and Scripting

Hi!

I am trying to create a script to reorder the contents of a text file. Below is the text file initially, followed by how I would like it reordered:

File initially:
---
Initial lines with text and/or numbers
Initial lines with text and/or numbers
Initial lines with text and/or numbers
Initial lines with text and/or numbers
Initial lines with text and/or numbers

x1 y1 z1 num1
1 E1,1
2 E1,2
3 E1,3
4 E1,4
5 E1,5
6 E1,6
...
{note to forum: there is always one linespace in between}
x2 y2 z2 num2
1 E2,1
2 E2,2
3 E2,3
4 E2,4
5 E2,5
6 E2,6
...

(The above sections are repeated hundreds of times.)

File reordered:
---
x y z 1 2 ...
x1 y1 z1 E1,1 E1,2 ...
x2 y2 z2 E2,1 E2,2 ...
...

I hope this makes sense. Essentially I need to be able to generate an Excel plot of x, y and z versus the energies. Other notes:

1. x1, y1, z1, E1,1 etc. are all numbers (decimals and floating point).
2. The '1', '2', '3', ... numbers above are exactly what appears.

Any help that can be provided would be great! I have attached a copy of the real initial file.

Thanks!
gwr

Code:

awk 'A&&NF!=2{A=0} A{printf A" ";L=1;A=x} /^$/&&L{print;L=0} L{printf " "$2","$1} NF==4{A=$1" "$2" "$3" "$4}' eigenval

Thanks Chubler_XL!

When I execute that though as follows, I get the attached output file which I can't plot.

Code:

#!/bin/bash

var1=$(awk 'A&&NF!=2 {A=0} A{ printf A" "; L=1; A=x} /^$/&&L { print; L=0 } L{ printf " "$2","$1} NF==4 {A=$1" "$2" "$3" "$4}' EIGENVAL)

echo ${var1} >> out.txt

exit

Am I doing something wrong?

Thanks again,
gwr

Yes, just redirect output directly to your out.txt:

Code:

#!/bin/bash
awk 'A&&NF!=2{A=0} A{printf A" ";L=1;A=x} /^$/&&L{print;L=0} L{printf " "$2","$1} NF==4{A=$1" "$2" "$3" "$4}' eigenval > out.txt

Thanks Chubler_XL! Works a treat.

gwr

Hi Chubler_XL,

One further question. Attached is the Excel file I get when I import the resulting text file, delimiting it by space and comma. Notice the columns with all 1's, 2's, 3's, etc. Is there anyway to get rid of these columns? It's a real pain for plotting. Preferably, I would like these numbers to appear once above their respective energy columns as headings.

Thanks again!

gwr

Yep this should do it - just using comma as delimiter now:

Code:

awk '
NR==FNR{if(Z&&NF!=2)Z=0;if(Z)C=C>$1?C:$1;if(NF==4)Z=1;next}
C{printf "X,Y,Z,GWR,";while(--C)printf ++i",";print ++i}
A&&NF!=2 {A=0} A{ printf A; L=1; A=x} /^$/&&L{print;L=0}
L{printf ","$2} NF==4{A=$1","$2","$3","$4}' eigenval eigenval > out.txt