{"id":68373,"date":"2005-12-08T14:55:00","date_gmt":"2005-12-08T14:55:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2005\/12\/08\/how-can-i-convert-names-to-proper-case\/"},"modified":"2005-12-08T14:55:00","modified_gmt":"2005-12-08T14:55:00","slug":"how-can-i-convert-names-to-proper-case","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/how-can-i-convert-names-to-proper-case\/","title":{"rendered":"How Can I Convert Names to Proper Case?"},"content":{"rendered":"

\"Hey, \n

Hey, Scripting Guy! I have a script that my help desk people use to create user accounts. Unfortunately, sometimes these help desk personnel get in a hurry and type in names like this: kEn MYEr. How can I convert names to proper case (i.e., Ken Myer)?

— LC<\/P>\"Spacer\"\"Hey,\"Script<\/A> \n

Hey, LC. You know what: you\u2019re in luck. Usually when it comes to doing anything properly the Scripting Guys are the last<\/I> people you\u2019d want to ask. In fact, the only exception that we know of is converting names to proper case, with the first letter in the name written in uppercase and the remaining letters written in lowercase. That<\/I> we can do.<\/P>\n\n<\/THEAD>\n\n\n
\n

Note<\/B>. Hey, everyone has to be able to do something<\/I>. And while we would have preferred being able to throw a fastball past Albert Pujols or winning an Olympic gold medal, being able to convert names to proper case would have been our next choice anyway.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n

<\/DIV>\n

We\u2019ll warn you in advance that the script that performs this task might look a bit cryptic; that\u2019s because VBScript (unlike Visual Basic) doesn\u2019t have a built-in method for converting strings to proper case. But that\u2019s OK; after all, if it was too<\/I> easy it wouldn\u2019t be any fun:<\/P>

strFirstName = “kEn”\nstrLastName = “MYEr”<\/p>\n
intFirstName = Len(strFirstName)\nstrFirstLetter = UCase(Left(strFirstName, 1))\nstrRemainingLetters = LCase(Right(strFirstName, intFirstName – 1))<\/p>\n
strFirstName = strFirstLetter & strRemainingLetters<\/p>\n
intLastName = Len(strLastName)\nstrFirstLetter = UCase(Left(strLastName, 1))\nstrRemainingLetters = LCase(Right(strLastName, intLastName – 1))<\/p>\n
strLastName = strFirstLetter & strRemainingLetters<\/p>\n
Wscript.Echo strFirstName, strLastName\n<\/PRE>\n
Let\u2019s walk you through the process. To begin with, we simply assign the values kEn<\/B> and MYEr<\/B> to variables named strFirstName and strLastName; these, needless to say, are the two names we need to convert.<\/P>\n\n<\/THEAD>\n\n\n
\n
Note<\/B>. Yes, even though it was needless to say, we said it anyway. Go figure.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n
<\/DIV>\n
Seeing as how first things are supposed to come first, we begin by tackling the user\u2019s first name. To do that, we use the Len<\/B> function to determine the number of letters in the string kEn (you got it: there are 3 letter in kEn):<\/P>
intFirstName = Len(strFirstName)\n<\/PRE>\n
Next we need to grab just the first letter<\/I> of the name and convert it to uppercase. We do that by combining a pair of functions. We use the Left<\/B> function to take the first letter; that is, we take one letter from the left side of the string (in case you\u2019re wondering, the 1<\/B> indicates the number of letters we want to grab):<\/P>
Left(strLastName, 1)\n<\/PRE>\n
That\u2019s going to give us the letter k. We then use the UCase<\/B> function to convert that letter to uppercase:<\/P>
UCase(Left(strLastName, 1))\n<\/PRE>\n
We now have the uppercase letter K which we store in a variable named strFirstLetter. That\u2019s an awful lot, yet all those steps are carried out in a single line of code:<\/P>
strFirstLetter = UCase(Left(strLastName, 1))\n<\/PRE>\n
See how that works? OK. Now we need to convert all the remaining letters in the name to lowercase. That\u2019s what we do with this line of code:<\/P>
strRemainingLetters = LCase(Right(strLastName, intLastName – 1))\n<\/PRE>\n
Yes, it does<\/I> look a little crazy. So let\u2019s break it down. What we want to do is take all the letters in the first name except<\/I> for the very first letter. To do that we use the Right<\/B> function and, beginning from the right, take x<\/I> number of letters. What is x<\/I>? Well, in this case x<\/I> will be the total number of letters in the string minus 1. In other words, 3 – 1, or 2. That\u2019s going to give us the letters En (which is all we want) leaving out the initial letter k.<\/P>\n
Make sense? Here\u2019s the code that does that:<\/P>
Right(strLastName, intLastName – 1)\n<\/PRE>\n
And what do we do<\/I> with those letters? Well, this time we use the LCase <\/B>function to convert each letter to lowercase:<\/P>
LCase(Right(strLastName, intLastName – 1))\n<\/PRE>\n
After that we take those lowercase letters and stash them in a variable named strRemainingLetters:<\/P>
strRemainingLetters = LCase(Right(strLastName, intLastName – 1))\n<\/PRE>\n
Yes, it can be a little confusing. But walk yourself through the code a time or two and you should catch on. Alternatively, modify the code and do the Left\/Right thing first and then<\/I> call UCase or LCase:<\/P>
intFirstName = Len(strFirstName)<\/p>\n
strFirstLetter = Left(strFirstName, 1)\nstrFirstLetter = UCase(strFirstLetter)<\/p>\n
strRemainingLetters = Right(strFirstName, intFirstName – 1)\nstrRemainingLetters = LCase(strRemainingLetters)\n<\/PRE>\n
If it helps to do things step-by-step, well, so much the better.<\/P>\n
Finally, we need to reconstruct the user\u2019s first name. To do that we use the variable strFirstLetter (which contains the uppercase version of the first letter in the user\u2019s name) and combine it with the variable strRemainingLetters (which contains the lowercase version of all the remaining letters in the user\u2019s name):<\/P>
strFirstName = strFirstLetter & strRemainingLetters\n<\/PRE>\n
We repeat this entire process for the last name, then echo back the \u201cnew\u201d first and last names for our user:<\/P>
Wscript.Echo strFirstName, strLastName\n<\/PRE>\n
And what do we get when we do this?<\/P>
Ken Myer\n<\/PRE>\n
It\u2019s a thing of beauty. And properly done, too!<\/P>
<\/p>\n","protected":false},"excerpt":{"rendered":"
Hey, Scripting Guy! I have a script that my help desk people use to create user accounts. Unfortunately, sometimes these help desk personnel get in a hurry and type in names like this: kEn MYEr. How can I convert names to proper case (i.e., Ken Myer)?— LC Hey, LC. You know what: you\u2019re in luck. […]<\/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":[3,4,21,5],"class_list":["post-68373","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-scripting-guy","tag-scripting-techniques","tag-string-manipulation","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! I have a script that my help desk people use to create user accounts. Unfortunately, sometimes these help desk personnel get in a hurry and type in names like this: kEn MYEr. How can I convert names to proper case (i.e., Ken Myer)?— LC Hey, LC. You know what: you\u2019re in luck. […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68373","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=68373"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/68373\/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=68373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=68373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=68373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}