{"id":55303,"date":"2008-06-21T02:16:00","date_gmt":"2008-06-21T02:16:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2008\/06\/21\/hey-scripting-guy-how-can-i-change-the-letter-case-of-my-file-names\/"},"modified":"2008-06-21T02:16:00","modified_gmt":"2008-06-21T02:16:00","slug":"hey-scripting-guy-how-can-i-change-the-letter-case-of-my-file-names","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-change-the-letter-case-of-my-file-names\/","title":{"rendered":"Hey, Scripting Guy! How Can I Change the Letter Case of My File Names?"},"content":{"rendered":"

\"Hey,<\/p>\n

Hey, Scripting Guy (and the $12 million-a-year Scripting Editor)! Is there a way to mass-rename all the files in a folder, changing the letter case as needed?<\/p>\n

— MV<\/p>\n

\"Spacer\"\"Hey,\"Script<\/a><\/p>\n

Hey, MV. To begin with, we should mention that we know that you actually asked two questions in your email. We’re going to deal with the first question – mass-renaming of all the files in a folder, changing the letter case as needed – today, then address your other question sometime in the next week or so. Originally the plan was to answer both questions today: the Scripting Guy who writes this column would address the mass-renaming issue, and the Scripting Editor would tackle your other question (a question that has to do with changing the tags on MP3 files). Unfortunately, though, the $12 million-a-year Scripting Editor<\/strong><\/a> is not available today; she had to fly down to California to buy a pair of sunglasses.<\/p>\n

And yes, we know: that does<\/i> sound a bit extravagant, flying all the way to California just to pick up a pair of sunglasses. To her credit, though, the Scripting Editor originally ran down to Walgreen’s, hoping to pick up a pair of sunglasses off the rack. Unfortunately, Walgreen’s didn’t have what she was looking for; she needed sunglasses in 18K Yellow Gold, with 132 hand-set, full-cut diamonds, as well as a 2.0 carat Canary yellow diamond. And, of course, ivory buffalo horn temples and brown lenses with gold mirror. Sadly, she couldn’t get ivory buffalo horn temples at Walgreen’s; all their temples are made out of Alaskan walrus tusk. That left her no choice but to zip down to Studio City, CA and pick up a pair of sunglasses down there.<\/p>\n\n<\/thead>\n\n\n
\n

Note<\/strong>. OK, so maybe she didn’t have<\/i> to go down to California herself; she probably could have ordered them online<\/strong><\/a>. Which reminds us: if anyone out there is interested in being just like the Scripting Editor – and we have to assume that everyone<\/i> is interested in being just like the Scripting Editor – these sunglasses are currently on sale for just $65,000. That means you can get both the sunglasses and a $2,600 pen-and-pencil set<\/strong><\/a> for less than $70,000!<\/p>\n

Who said you can’t find bargains anymore? You just have to be willing to look<\/i> for them.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

At any rate, once the Scripting Editor returns from her skin tightening (gift cards<\/strong><\/a> available!) she’ll no doubt address MV’s question about MP3 files. In the meantime, the Scripting Guy who writes this column doesn’t need to have his skin tightened. (As far as he knows, anyway; after all, it hasn’t fallen off or anything, at least not yet.) Therefore, he has time to go ahead and tackle MV’s first question: is there a way to mass-rename all the files in a folder, changing the letter case as needed? <\/p>\n

The answer, of course, is yes, depending on what you mean by “changing the letter case as needed.” Let’s start with a very simple example. Suppose you have files (in the folder C:\\Test) that look like this:<\/p>\n

This is A file.Txt\nTHIS IS ANOTHER FILE.TXT\nthis is the third file.TXT\nTHIS IS THE LAST FILE.txt\n<\/pre>\n
Needless to say, this isn’t the prettiest directory listing we’ve ever seen. (Especially when compared to the Madera bathtub<\/strong>, hand-crafted from natural solid woods and priced to sell 
at just $30,000 apiece. Pick up one for each member of the family; after all, you can never have too many hand-crafted wooden bathtubs.) Because of that, we might want to convert 
all the letters in both the file name and the file extension to their lowercase equivalent, giving us a directory listing that looks like this:<\/p>\n
this is a file.txt\nthis is another file.txt\nthis is the third file.txt\nthis is the last file.txt\n<\/pre>\n
So how are we going to do that? Why, by running the following script, of course:<\/p>\n
strComputer = \".\"\n\nSet objWMIService = GetObject(\"winmgmts:\\\\\" & strComputer & \"\\root\\cimv2\")\n\nSet colFileList = objWMIService.ExecQuery _\n    (\"ASSOCIATORS OF {Win32_Directory.Name='C:\\Test'} Where \" _\n        & \"ResultClass = CIM_DataFile\")\n\nFor Each objFile In colFileList\n    strName = LCase(objFile.FileName)\n    strExtension = LCase(objFile.Extension)\n\n    strNewName = objFile.Drive & objFile.Path & strName & \".\" & strExtension\n    objFile.Rename(strNewName)\nNext\n<\/pre>\n
Let’s see what we have here. We kick things off by connecting to the WMI service on the local computer. And yes, we can<\/i> run this script – and thus rename files – on a remote computer; 
all we have to do is assign the name of that remote machine to the variable strComputer:<\/p>\n
strComputer = \"atl-fs-001\"<\/pre>\n
After connecting to the WMI service we then use this line of code to return a collection of all the files found in the folder C:\\Test:<\/p>\n
Set colFileList = objWMIService.ExecQuery _\n    (\"ASSOCIATORS OF {Win32_Directory.Name='C:\\Test'} Where \" _\n        & \"ResultClass = CIM_DataFile\")\n<\/pre>\n
And now it’s time to have some fun. (As much fun as an $18,000 stainless steel pool table<\/strong><\/a>? Well, no. But close. Very close.)<\/p>\n
To begin with, we set up a For Each loop that enables us to loop through all the files in the collection. Inside that loop the first thing we do is execute these two lines of code:<\/p>\n
strName = LCase(objFile.FileName)\nstrExtension = LCase(objFile.Extension)\n<\/pre>\n
In the first line we’re assigning a value to the variable strName. What value are we assigning? Well, we’re taking the value of the FileName<\/strong> property and using the LCase<\/strong> function to 
convert all the characters in that file name to their lowercase equivalent. In other words, suppose the name of our first file is This is A file<\/strong>. The LCase function will convert 
that file name to the following:<\/p>\n
this is a file<\/pre>\n
In the second line of code we use the same approach to convert all the letters in the file extension to their<\/i> lowercase equivalent.<\/p>\n
Believe it or not, at this point we’re almost done. When you rename files using WMI you must supply the Rename<\/strong> method with a complete file path; this line of code helps us put together 
a complete file path, substituting the variables strName and strExtension for the file name and the file extension:<\/p>\n
strNewName = objFile.Drive & objFile.Path & strName & \".\" & strExtension<\/pre>\n
All that’s left now is to call the Rename method and rename the first file:<\/p>\n
objFile.Rename(strNewName)<\/pre>\n
And then it’s back to the top of the list, where we repeat the process with the next file in the collection. When all is said and done, the folder C:\\Test should now look like this:<\/p>\n
this is a file.txt\nthis is another file.txt\nthis is the third file.txt\nthis is the last file.txt\nNot bad, eh? And, of course, you could easily convert all the letters in the file names to their uppercase<\/i> equivalent. To do that, simply use the UCase<\/strong> function rather than the LCase 
function.<\/pre>\n
Well that was easy, wasn’t it? And fast, too: we’ve still got time to do something else today. Enough time to spend a night at the Atlantis Bridge <\/strong>Suite in the Atlantis <\/strong>Hotel in the Bahamas<\/strong><\/a> 
($25,000 per night)? Sadly, no. (Besides, the Scripting Editor says the place is overrated, although she does like the fact that the kitchen has a separate entrance, meaning that she never 
actually has to see the cook or butler.) However, we do<\/i> have time to tackle a more ambitious script, one that applies “title casing” to our file names. In other words, a script that can turn our 
file names into these:<\/p>\n
This Is A File.txt\nThis Is Another File.txt\nThis Is The Third File.txt\nThis Is The Last File.txt\n<\/pre>\n
How are we going to do that<\/i>? Good question; maybe we should try running this script and see what happens:<\/p>\n
strComputer = \".\"\n\nSet objWMIService = GetObject(\"winmgmts:\\\\\" & strComputer & \"\\root\\cimv2\")\n\nSet colFileList = objWMIService.ExecQuery _\n    (\"ASSOCIATORS OF {Win32_Directory.Name='C:\\Test'} Where \" _\n        & \"ResultClass = CIM_DataFile\")\n\nFor Each objFile In colFileList\n    strName = objFile.FileName\n    strExtension = LCase(objFile.Extension)\n\n    arrWords = Split(strName, \" \")\n\n    For i = 0 to UBound(arrWords)\n        intLength = Len(arrWords(i))\n        strFirstLetter = UCase(Left(arrWords(i), 1))\n        strOtherLetters = LCase(Right(arrWords(i), intLength - 1))\n        strName = strFirstLetter & strOtherLetters\n        arrWords(i) = strName\n    Next\n\n    strNewName = Join(arrWords, \" \")\n    strNewName = objFile.Drive & objFile.Path & strNewName & \".\" & strExtension\n    objFile.Rename(strNewName)\nNext\nSo how does this<\/i> script work? Well, in many ways it works the same as the first script we showed you: it connects to the WMI service, retrieves a collection of all the files 
in the folder C:\\Test, and then assigns the file name and extension to a pair of variables:<\/pre>\n
strName = objFile.FileName\nstrExtension = LCase(objFile.Extension)\nAt this point, however, things start to diverge a little. To begin with, we use the Split<\/strong> function to convert our file name (This is A file) to an array, an array consisting of the 
following items:<\/pre>\n\n\n\n\n\n\n
•<\/td>\n\n
This <\/p>\n<\/td>\n<\/tr>\n
•<\/td>\n\n
is <\/p>\n<\/td>\n<\/tr>\n
•<\/td>\n\n
A <\/p>\n<\/td>\n<\/tr>\n
•<\/td>\n\n
file<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
As you can see, by splitting on the blank space we’ve created an array where each item represents a single word in the file name. Once we’ve done that we can 
execute this block of code:<\/p>\n
For i = 0 to UBound(arrWords)\n    intLength = Len(arrWords(i))\n    strFirstLetter = UCase(Left(arrWords(i), 1))\n    strOtherLetters = LCase(Right(arrWords(i), intLength - 1))\n    strName = strFirstLetter & strOtherLetters\n    arrWords(i) = strName\nNext\n<\/pre>\n
What we’ve done here is set up a For Next loop that runs from 0 to the number of items in the array (the “upper bound” of the array, something we can determine 
using the UBound<\/strong> function). Inside that loop we use the Len<\/strong> function to determine the number of characters in the first item (word) in the array. From there we can 
use this line of code to grab the first letter in that value and convert it to an uppercase letter:<\/p>\n
strFirstLetter = UCase(Left(arrWords(i), 1))<\/pre>\n
And then we can use this<\/i> line of code to grab all the remaining characters in the value (that is, everything except<\/i> the first character) and convert them to lowercase 
letters:<\/p>\n
strOtherLetters = LCase(Right(arrWords(i), intLength - 1))<\/pre>\n
We next combine our uppercase first letter with our lowercase remaining letters, then assign that combined value back to the array item:<\/p>\n
strName = strFirstLetter & strOtherLetters\narrWords(i) = strName\nWhat does that<\/i> mean? Well, suppose the first item in the array was tHIs<\/i>. After running through this For Next loop, that first item will now be This<\/i>. In other words, we’ve capitalized 
the first letter in the word, and made the remaining letters all lowercase.<\/pre>\n
After we repeat this process for all the items in the array we use the Join<\/strong> function to convert the array back to a string, separating each item (word) with a blank space. In other 
words, if we started out with this file name:<\/p>\n
This is A file<\/pre>\n
We’re going to end up with this<\/i> file name:<\/p>\n
This Is A File<\/pre>\n
At that point we simply call the Rename<\/strong> method to rename the file, then go back to the top of our For Each loop and try again with the next file in the collection.<\/p>\n
Is that really going to apply title casing to all our file names? Give it a try and see for yourself.<\/p>\n
That’s all we have time for today, MV; like we said, we’ll address your other question after the Scripting Editor gets back. In the meantime, the Scripting Guy who writes this 
column needs to get some new sunglasses himself. However, he will<\/i> simply pick up a pair at Walgreen’s; the Scripting Guy who writes this column doesn’t need to jet down 
to California just to buy sunglasses. The truth is, he doesn’t need sunglasses that have temples made of ivory buffalo horn. No, sir: as long as the sunglasses keep the glare 
out of his eyes he’s happy.<\/p>\n
Well, provided they also come with 132 hand-set, full-cut diamonds. But if the temples are made out of Alaskan walrus tusk? Hey, no problem; he’s not picky.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy (and the $12 million-a-year Scripting Editor)! Is there a way to mass-rename all the files in a folder, changing the letter case as needed? — MV Hey, MV. To begin with, we should mention that we know that you actually asked two questions in your email. We’re going to deal with the […]<\/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-55303","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 (and the $12 million-a-year Scripting Editor)! Is there a way to mass-rename all the files in a folder, changing the letter case as needed? — MV Hey, MV. To begin with, we should mention that we know that you actually asked two questions in your email. We’re going to deal with the […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55303","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=55303"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/55303\/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=55303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=55303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=55303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}