Using File Search Pattern

[vgwprja]

I am presently selecting pattern = *.txt and it works fine. I need to narrow the scope and select a pattern like this: tovecellio*.txt, it does not seem to find any files even if they are present.

Present code:

Set objRegExp = New RegExp
objRegExp.Pattern = "*.txt"
objRegExp.IgnoreCase = True

For Each objFile In fileColl
If objRegExp.Test(objFile.Name) Then........

 

[dm4ever]

Shouldn't the pattern be more like tovecellio.*\.txt

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[sparkbyte]

To add to DM4Ever's example, your selection pattern needs to be in the form of a Regular Expression which may (probably) be different that what you are used to.

You code example is using regular expressions to match patterns.

Hope this helps...

John Fuhrman

 

[tsuji]

>I am presently selecting pattern = *.txt and it works fine.
>objRegExp.Pattern = "*.txt"
In what sense it works fine? This is blatantly non-sense. Is that your script or you're just the go-between?

 

[sparkbyte]

Wow tsuji, that was a bit harsh.

Yes, it is a bit obvious the user is not aware that the code example is using regular expressions and "*.txt" would not work.

vgwprja, for that part of your code to work you will need to do some reading on how to use regular expressions for text string matching. I will warn you though, this can be daunting because of the power and flexibility of regular expressions.

Once you have done this and can post an example script of what your trying do do, we will then have a better idea of how to help you with your script.

Hope this helps you and doesn't scare you away from Tek-Tips. I have used Tek-Tips for a couple of years now and everyone (including tsuji) has been an incredible asset. dm4ever and tsuji both have a knack for seeing very creative and easily understood solutions to problems.

Thanks
John Fuhrman

 

[bryne]

Harsh? Absolutely and inconsiderate as well. There are other forums out there

 

[tsuji]

If they are considerate, they won't leave thread pending after good advice is given. I am here to uphold the minimum pride of professionalism this forum and the others deserve by the efforts of their good members.

 

[bryne]

Leave threads pending? I'm sure that was not the intent. Sep 5 was a Friday followed by the week end (at least in the western hemisphere). Please give the orginator time to absorb and manage the thread.