I have already written T-SQL Function to convert a string into Camel Case. In this article I am going to share same function but in Visual Basic code. This function can be used directly in SSRS code.
Here is Visual Basic code to convert a string into Camel Case (Proper case):
Public Function CamelCaseInVB(ByVal str as String) as String
Dim strFinal As String
Dim i As Integer
scrstr = Trim(LCase(str))
i = 1
If str.Length > 0 Then
While i <= str.Length
If i = 1 Then
strFinal = strFinal + UCase(Mid(str, i, 1))
i = i + 1
ElseIf Asc(Mid(str, i, 1)) = 32 Then
strFinal = strFinal + Space(1) + UCase(Mid(str, i + 1, 1))
i = i + 2
ElseIf Asc(Mid(str, i, 1)) = 40 Then
strFinal = strFinal +"(" + UCase(Mid(str, i + 1, 1))
i = i + 2
Else
strFinal = strFinal + Mid(str, i, 1)
i = i + 1
End If
End While
End If
Return strFinal
End Function
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.