Excel VBA ---Text File counting
 

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

Excel VBA ---Text File counting
 

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

Excel VBA ---Text File counting
 

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

Excel VBA ---Text File counting
 

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

Excel VBA ---Text File counting
 

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