in reply to Re^5: regarding file from the directory and executing some commands and placing the out put on exceel sheet.
in thread regarding file from the directory and executing some commands and placing the out put on exceel sheet.

Hi,

Now i am getting the output on two lines

But i want write these to excel sheet and i am using

my @row1 = ('Jun-2013',$Gkel_gz[0],$Gkel_gz[1],$TT1[0]->[0],$TT1[0]->[ +1],$Gkel[0],$Gkel[1]); my @row2 = ($TT1[1]->[0],$TT1[1]->[1]); print DETAIL "Jun-2013,$Gkel_gz[0],$Gkel_gz[1],$Gkel_gz[1],$TT1[0]->[0 +],$TT1[0]->[1],$Gkel[0],$Gkel[1],$Gkel[1],TRUE\n"; print DETAIL "'\t','\t','\t','\t',$TT1[1]->[0],$TT1[1]->[1]\n";

Output what i am getting now

Line numebr 1

Jun-2013 Gkel_check.1.ABC.dat.gz count check.1.ABC_TT1.dat count check +.1.ABC.dat.gz count

Line numebr 2

check.1.AB_TT1.dat count

but i want the line number 2 output below check.1.ABC_TT1.dat count

Expected

Jun-2013 Gkel_check.1.ABC.dat.gz count check.1.ABC_TT1.dat count check +.1.ABC.dat.gz count check.1.AB_TT1.dat count

And also the regards,

  • Comment on Re^6: regarding file from the directory and executing some commands and placing the out put on exceel sheet.
  • Select or Download Code