Hi,

sorry for the confusion

Gkel_check.1.ABC.dat.gz Gkel_check.1.ABC.dat check.1.ABC_TT1.dat check.1.AB_TT1.dat
if (($file=~ m/^Gkel_/) && (substr($file, -2) eq 'gz')) { my $result = `gunzip -c $file|tail -1`; $Count = substr($result,22,8); system(`gunzip -f $file`); $Orig_file = $file;

The above condition i am using to fetch the files starts with Gkel_ abd ends with gz

fetch the zip file and execute tail command to get the count

and execute gunzip to uncompress the file, here i will take the file name and count

elsif ($file=~ m/^check.*TT1.dat$/) my $result = `wc -l $file`; my ($count, $file_name) = split(' ',$result); $result{$hashkey}->[0] = $file_name; $result{$hashkey}->[1] = $count; $hashkey++;

The above code to fetch the two files check.1.ABC_TT1.dat and check.1.AB_TT1.dat

execute the wc -l to get the count here also i will take the file name and count

opendir( DIR, $dir ); my @files = grep( /$pattern/, readdir(DIR) ); closedir(DIR); chdir($dir); foreach my $file (@files) { if (($file=~ m/^Gkel_/) && (substr($file, -2) ne 'gz')) { my $result = `wc -l $file`; my ($count, $file_name) = split(' ',$result); $file1 = substr($file,5,50); $Orig_file1 = $file_name; $Count1 = $count; system(`mv $file $file1`); } }

The above code will take the unzipped file Gkel_check.1.ABC.dat and

and move the file from Gkel_check.1.ABC.dat to check.1.ABC.dat

execute the wc -l to get the count here also i will take the file name and count

Output what i am expecting is:

June-2013 Gkel_check.1.ABC.dat.gz count check.1.ABC_TT1.dat count chec +k.1.ABC.dat.gz count

This is the first line the above output should contain a line with zip file name and its count

Then check.1.ABC_TT1.dat and its count and unzipped file name and count

check.1.AB_TT1.dat

In second line i need just only check.1.AB_TT1.dat file name and its count

regards,

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

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.