Hello all
thanks in advance for reading this post-- hope it makes some sense

We have a folder which has log files. say folder "LOG" have files
"sample.log" and so on..
is there a way to count the number of times a specific text has occured in
that sample.log ...for example if there's a word "Load" in the log file.. is
theres a way that i can automate this process so that if i input the folder
to the VBA it generates the Number of "Load" in that sample.log and Displayes
the count in excel sheet at a specified location.

if i have many such log files in a same folder , is there a way to count all
the "load" text for every single file and place them seperatly for each.

Any help would be most appreciated,

Thanks

Ajay Tummala
Paceco Corp

Try to stick to one thread.

Can "Load" appear multiple times on one line, or only once ?

--
Tim Williams
Palo Alto, CA


"Please help in building a Vba in excel" soft.com wrote in message
...
Hello all
thanks in advance for reading this post-- hope it makes some sense

We have a folder which has log files. say folder "LOG" have files
"sample.log" and so on..
is there a way to count the number of times a specific text has occured in
that sample.log ...for example if there's a word "Load" in the log file.. is
theres a way that i can automate this process so that if i input the folder
to the VBA it generates the Number of "Load" in that sample.log and Displayes
the count in excel sheet at a specified location.

if i have many such log files in a same folder , is there a way to count all
the "load" text for every single file and place them seperatly for each.

Any help would be most appreciated,

Thanks

Ajay Tummala
Paceco Corp

This was my first post so was not sure, i could not find my post ,so did a
repost.

Can "Load" appear multiple times on one line, or only once ?

No, Load appears many times in the log file but not on one line.

Thanks for ur reply.

"Tim Williams" wrote:

Try to stick to one thread.

Can "Load" appear multiple times on one line, or only once ?

--
Tim Williams
Palo Alto, CA


"Please help in building a Vba in excel" soft.com wrote in message
...
Hello all
thanks in advance for reading this post-- hope it makes some sense

We have a folder which has log files. say folder "LOG" have files
"sample.log" and so on..
is there a way to count the number of times a specific text has occured in
that sample.log ...for example if there's a word "Load" in the log file.. is
theres a way that i can automate this process so that if i input the folder
to the VBA it generates the Number of "Load" in that sample.log and Displayes
the count in excel sheet at a specified location.

if i have many such log files in a same folder , is there a way to count all
the "load" text for every single file and place them seperatly for each.

Any help would be most appreciated,

Thanks

Ajay Tummala
Paceco Corp

Specific words could be "Load" Discharge"...sanity etc
and the case is important.

thanks

"Tim Williams" wrote:

Try to stick to one thread.

Can "Load" appear multiple times on one line, or only once ?

--
Tim Williams
Palo Alto, CA


"Please help in building a Vba in excel" soft.com wrote in message
...
Hello all
thanks in advance for reading this post-- hope it makes some sense

We have a folder which has log files. say folder "LOG" have files
"sample.log" and so on..
is there a way to count the number of times a specific text has occured in
that sample.log ...for example if there's a word "Load" in the log file.. is
theres a way that i can automate this process so that if i input the folder
to the VBA it generates the Number of "Load" in that sample.log and Displayes
the count in excel sheet at a specified location.

if i have many such log files in a same folder , is there a way to count all
the "load" text for every single file and place them seperatly for each.

Any help would be most appreciated,

Thanks

Ajay Tummala
Paceco Corp

See my code in reply to your other post. Please refrain from posting the
same question in different messages.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Please help in building a Vba in excel"
soft.com wrote in message
...
Hello all
thanks in advance for reading this post-- hope it makes some sense

We have a folder which has log files. say folder "LOG" have files
"sample.log" and so on..
is there a way to count the number of times a specific text has occured in
that sample.log ...for example if there's a word "Load" in the log file..
is
theres a way that i can automate this process so that if i input the
folder
to the VBA it generates the Number of "Load" in that sample.log and
Displayes
the count in excel sheet at a specified location.

if i have many such log files in a same folder , is there a way to count
all
the "load" text for every single file and place them seperatly for each.

Any help would be most appreciated,

Thanks

Ajay Tummala
Paceco Corp