Filter list with values only including certain text

Questions & Suggestions
1

I have a macro that reads the files listed in a folder and sets a variable to the names. I only want to work with files that the name of the file contains _OCR. How can I filter my list of file names to show only those file names with _OCR included?

An example of a list of file names in a folder could be:
20200417_OCR.pdf
20200417.pdf
20200418_OCR.pdf
20200418.pdf

I am open to either filtering the list or learning how to set the initial variable of only files in a folder that contains _OCR in their name.

Thanks to anyone that can help!

2

If I understood you correctly, here is a quick example to get you started:

I tested this but make sure you test this out some demo files first.
This just searches for the files containing _OCR and replaces it with the date- for demo purposes. Your area of focus is the If statement with the Variable contains _OCR portion. From there, you can do what you want.

Screen Shot 2020-04-17 at 1.00.46 PM
Screen Shot 2020-04-17 at 1.00.46 PM1184×1530 125 KB

Try it out and let us know. We may be able to get you closer to what you are trying to accomplish.

KC

3

Here's an example macro that does what you ask, and more, so it should be a good guide you can use for your macro:

MACRO: Get List of FileNames That Match Criteria [Example]