Process files for excel use 1

[jdespres]

I have been collecting data all weekend on the hour...

Each file has the following format:

Sat Jul 29 12:00:00 EDT 2006
server1 numerical_data1
server2 numerical_data2
server3 numerical_data3
server4 numerical_data4
server5 numerical_data5
server6 numerical_data6
server7 numerical_data7
server8 numerical_data8

Sat Jul 29 13:00:00 EDT 2006
server1 numerical_data1
server2 numerical_data2
server3 numerical_data3
server4 numerical_data4
server5 numerical_data5
server6 numerical_data6
server7 numerical_data7
server8 numerical_data8

I would like to collect all data into one file ready for import into excel:

Jul 29 12:00:00 Jul 29 13:00:00 Jul 29 14:00:00
server1 numerical_data1 numerical_data1 numerical_data1 ..
server2 numerical_data2 numerical_data2 numerical_data2 ..
server3 numerical_data3 numerical_data3 numerical_data3 ..
server4 numerical_data4 numerical_data4 numerical_data4 ..
server5 numerical_data5 numerical_data5 numerical_data5 ..
server6 numerical_data6 numerical_data6 numerical_data6 ..
server7 numerical_data7 numerical_data7 numerical_data7 ..
server8 numerical_data8 numerical_data8 numerical_data8 ..

There's atleast 48 files.......

I was going to just manually cut and paste....

But I'm hoping there's a better way....

Thanks.......

Joe Despres

 

[KenCunningham]

cat file1 file2 file3... > newfile

 

[feherke]

Hi

There is an adequate tool, someone will tell you which. Until then, an [tt]awk[/tt] :

awk 'NR==FNR{s[FNR]=(FNR==1?FS:"")$0;next}{$1=FS (FNR==1?$1:"");s[FNR]=s[FNR]$0}END{for(i=1;i in s;i++)print i,s[i]}' /input/f*

Tested with [tt]gawk[/tt] and [tt]mawk[/tt].

Feherke.

http://rootshell.be/~feherke/

 

[jdespres]

$ awk 'NR==FNR{s[FNR]=(FNR==1?FS:"")$0;next}{$1=FS (FNR==1?$1:"");s[FNR]=s[FNR]$0}END{for(i=1;i in s;i++)print i,s}' VolumeAmount.rpt*
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: illegal statement near line 1
awk: syntax error near line 1
awk: illegal statement near line 1
awk: illegal statement near line 1

 

[cspilman]

What OS?

Regards,
Chuck

 

[feherke]

Hi

jdespres, I pasted back in my terminal the code you used and still works for me with [tt]gawk[/tt] 3.1.1 and [tt]mawk[/tt] 1.3.3.

Feherke.

http://rootshell.be/~feherke/

 

[KenCunningham]

Sorry - misread the original post. Having a bad day!!

 

[jdespres]

hhhhhmmmmm....
.
Using awk on a Solaris 9.....
.
I do have access to nawk....
.
It seems to work....
.
The output doesn't seem to be ok....

 

[feherke]

Hi

The output doesn't seem to be ok...

If you tell us why doesn't seem to be ok, we could help more efficiently...

Maybe you want a proper separator instead of [tt]FS[/tt] ?

awk 'NR==FNR{s[FNR]=(FNR==1?[red]"\t"[/red]:"")$0;next}{$1=[red]"\t"[/red] (FNR==1?$1:"");s[FNR]=s[FNR]$0}END{for(i=1;i in s;i++)print i,s[i]}' /input/f*

Feherke.

http://rootshell.be/~feherke/