Shell Programming and Scripting

Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further..
Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like
file1 file2

Code:

00: 140       00: 235
01: 160       01:415
02: 248       02:871
..                 ....
23: 471       23: 734

i need to convert this text files data into excel sheet as hour in column1 file1 data in column2 file data in column3 as below:
o/p Excel sheet:

Code:

hour  file1   file2
00     140   235
01     160   415
02     248   871
...      ....       ....
23     471   734

Plz suggest to get the solution for the above mentioned prob asap..

Try this awk solution:

Code:

awk -F"[: ]*" '
  BEGIN{OFS=","; print "hour",ARGV[1], ARGV[2]}
  FNR==NR{A[$1]=$2;next}
  {print $1,A[$1]+0,$2} ' file1 file2 > sheet.csv