Shell Programming and Scripting

Thanks Chubler_XL, that's perfect.

Cheers,
gwr

Chubler_XL,

Can you help me? The commands you created were working great for the first file attached, until I encountered the second file attached, which doesn't work. The files should be the same, and I can't see a difference. But in the output from the awk command, the second file is not split into rows (two commas ,, appear where there should be a line break).

Attached files:
1. Original input file, for which awk command works perfectly
2. Original output file from awk command with input file from '1' above
3. New input file, for which awk doesn't work
4. New output file showing the rows not being divided

I need the command to work for both input file types, ideally. Your help would be greatly appreciated!!!

Thanks again,
gwr

Files attached now, sorry!

gwr

In file #2 the blank lines between datasets has some space characters in it, the following update should fix:

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 ",,,,";while(--C)printf ++i",";print ++i}
A&&NF!=2 {A=0} A{ printf A; L=1; A=x} /^[ \t]*$/&&L { print; L=0 } L{ printf ","$2} NF==4 { A=$1","$2","$3","$4}' EIGENVAL_2.txt EIGENVAL_2.txt

Thanks Chubler_XL! I will give that a try.

gwr