A Better Proper Case Function
Just copy/paste this function into your code, and it will allow you to convert a string to proper case. Now you've got UCase, LCase, AND PCase.
Original Author: Doug Tyson
Assumptions
I tried to account for as many "unimportant" words as I could, but I'm sure I've missed some. Just add any entries you feel necessary in the select statement.
Code
Function PCase(strInput)
'Variable declaration.
dim strArr
dim tmpWord
dim tmpString
dim last
'Create an array to store each word in the string separately.
strArr = split(strInput," ")
if ubound(strArr) > 0 then
for x = lbound(strArr) to ubound(strArr)
'Set each word to lower case initially.
strArr(x) = LCase(strArr(x))
'Skip the unimportant words.
select case strArr(x)
case "a"
case "an"
case "and"
case "but"
case "by"
case "for"
case "in"
case "into"
case "is"
case "of"
case "off"
case "on"
case "onto"
case "or"
case "the"
case "to"
case "a.m."
strArr(x) = "A.M."
case "p.m."
strArr(x) = "P.M."
case "b.c."
strArr(x) = "B.C."
case "a.d."
strArr(x) = "A.D."
case else
'Capitalize the first letter, but don't forget to take into account that
'the string may be in single or double quotes.
if len(strArr(x)) > 1 then
if mid(strArr(x),1,1) = "'" or mid(strArr(x),1,1) = """" then
tmpWord = mid(strArr(x),1,1) & Ucase(mid(strArr(x),2,1)) & mid(strArr(x),3,len(strArr(x))-2)
else
tmpWord = Ucase(mid(strArr(x),1,1)) & mid(strArr(x),2,len(strArr(x))-1)
end if
strArr(x) = tmpWord
end if
end select
'The unimportant words may need to be capitalized if they follow a dash, colon,
'semi-colon, single quote or double quote.
if x > 0 then
if instr(strArr(x-1),"-") _
or instr(strArr(x-1),":") _
or instr(strArr(x-1),";") then
tmpWord = Ucase(mid(strArr(x),1,1)) & mid(strArr(x),2,len(strArr(x))-1)
strArr(x) = tmpWord
end if
end if
next
else
strArr(0) = LCase(strArr(0))
end if
'Make sure the first word in the array is upper case, but don't forget to take into account
'that the string may be in single or double quotes.
if mid(strArr(0),1,1) = "'" or mid(strArr(0),1,1) = """" then
tmpWord = mid(strArr(0),1,1) & Ucase(mid(strArr(0),2,1)) & mid(strArr(0),3,len(strArr(0))-2)
else
tmpWord = Ucase(mid(strArr(0),1,1)) & mid(strArr(0),2,len(strArr(0))-1)
end if
strArr(0) = tmpWord
'Also, make sure the last word in the array is upper case, but don't forget to take into account
'that the string may be in single or double quotes.
last = ubound(strArr)
if mid(strArr(last),1,1) = "'" or mid(strArr(last),1,1) = """" then
tmpWord = mid(strArr(last),1,1) & Ucase(mid(strArr(last),2,1)) & mid(strArr(0),3,len(strArr(last))-2)
else
tmpWord = Ucase(mid(strArr(last),1,1)) & mid(strArr(last),2,len(strArr(last))-1)
end if
strArr(last) = tmpWord
'Rebuild the whole string from the array parts.
for x = lbound(strArr) to ubound(strArr)
tmpString = tmpString & strArr(x) & " "
next
PCase = tmpString
End Function
Loading Comments ...
Comments
No comments have been added for this post.
You must be logged in to make a comment.