intHours = DateDiff(\"h\", strFileDate, strCurrentDate)<\/pre>\nWhat DateDiff does is subtract the file’s creation date from the current date and time (stored in the variable strCurrentDate). Because we used the “h”<\/b> parameter that means that DateDiff will return the difference in hours. In other words, if our first file was created 12 hours ago then DateDiff will return the value 12 (which we promptly stash in the variable intHours). <\/p>\n
At that point we can check to see if intHours is less than or equal to 24:<\/p>\n
If intHours <= 24 Then<\/pre>\nWhat if intHours isn’t<\/i> less than or equal to 24? That’s fine; that just means that the file wasn’t created in the past 24 hours. In turn, that means we simply go back to the top of the loop and try again with the next file in the collection.<\/p>\n
But what if intHours is<\/i> less than or equal to 24? That means we need to check and see if the file name starts with any of our three designated letter sets. And how do we do that<\/i>? Why, by running these two lines of code, of course:<\/p>\nstrSearchString = objFile.FileName\nSet colMatches = objRegEx.Execute(strSearchString)<\/pre>\nIn the first line we’re simply taking the value of the FileName<\/b> property (minus the file extension) and storing it in a variable named strSearchString. In line 2, we use the Execute<\/b> method to run a regular expression search against this file name.<\/p>\n
And how do we know if the file name fit our criteria? That’s easy; we just check the regular expression Matches<\/b> collection; more specifically, we check to see if the collection’s Count<\/b> property is greater than 0:<\/p>\nIf colMatches.Count > 0 Then<\/pre>\nIf the Count is<\/i> greater than 0 that can mean only one thing: we have a match. In turn, that means we need to do two<\/i> things: we need to specify the location to where we want to copy the file (a location that must consist of a complete file path, including file name and extension); and, we need to copy the file to that location. That’s what these two lines of code are for:<\/p>\nstrNewFile = \"C:\\Test\\\" & objFile.FileName & \".\" & objFile.Extension
objFile.Copy(strNewFile)<\/pre>\nAnd then it’s back to the top of the loop, where we do this all over again with the next file in the collection.<\/p>\n
And that should do it, EM. It’s not exactly<\/i> what you were after, but it should work. And, as a little bonus, we showed you how you can search for any one of three possible patterns in a single regular expression. Can’t beat that, huh?<\/p>\n
Anyway, if that doesn’t solve all your problems, EM, well, just let us know; after all, we have access to an email that promises to “Put an end to your woes.” That sounds pretty nice. (Well, for those of you who, unlike the Scripting Guys, actually have<\/i> woes.) And, of course, there’s always the Tablet of Happiness. Like we said, just let us know.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! How can I match multiple criteria in a file name? I need to copy all the files in a folder that are less than 24 hours old, and that have file names beginning with the letters FS, CG, or GPS. How can I do that? — EM Hey, EM. You know, today […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[38,3,12,5],"class_list":["post-55263","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-files","tag-scripting-guy","tag-storage","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I match multiple criteria in a file name? I need to copy all the files in a folder that are less than 24 hours old, and that have file names beginning with the letters FS, CG, or GPS. How can I do that? — EM Hey, EM. You know, today […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=55263"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55263\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=55263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=55263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=55263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
<\/p>\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/a><\/p>\n