Searching many text files for a string

[Wyattwic]

Hello everyone! I'm new to the forums and my first post is a question post, sorry! It's nice to meet y'all!

I am stumped on how to do this, any assistance would be appreciated.

I have a folder containing 50-200 text files. In my excel document, I need to return a count of how many times a specific string occurred in those text files. I have about 50 different strings I need to get a count on.

How I am currently processing this is using notepad++'s search in files feature. I would search for the string inside the folder, then copy down the total results.

Assistance would be appreciated! Thank you!!

 

[Fennek]

Hello,

a possible way is to use the cmd find-function:

open the cmd-window
navigate to the folder
to find all "Hello" 
find /C "Hello" *.txt

If one trial is fine, it is possible to start (and loop though all search-word with xl-vba.

regards

 

[Fennek]

Hello again,

from my archiv:

Sub snb_find()
'sucht Text in Dateien
'Suchtext in " ", z.b. "Merkmal"
  sn = Split(CreateObject("wscript.shell").exec("cmd /c find  /N ""search-word"" c:\temp\*.txt ").stdout.readall, vbCrLf)

For Each d In sn
    Debug.Print d
  Next d
  
End Sub

The path, here c:\temp, must be adopted. And, a bit work on your side, the search-word must become flexible, a word from the sheet.

Pease try /n as well as /c

regards

 

[Wyattwic]

Thanks Fennek! I'm completely alien to visual basic, but those code examples look to be exactly what I need.

Once I have a final product, I'll post it back here.