Strings

The VBA code fragments below are included in the Code VBA fragments library. Fragments are snippets of code you can insert in your procedures. Each item between braces correspond to a variable of the given type. They are replaced with the new or existing variables by Fragment Builder in Code-VB tools.

• Add Single Quotes
• If Len gt 0
• If Len gt 0 Else
• Loop Chars in String
• Make First Character Uppercase
• String Append
• TRIM
• Use Default If Empty String

Add Single Quotes

{STRING} = "'" & {STRING} & "'"

If Len gt 0

If Len(STRING) > 0 Then 

If Len gt 0 Else

If Len(STRING) > 0 Then
    
Else

End If

Loop Chars in String

For {INTEGER} = 1 To Len({STRING:str})
    {STRING:char} = Mid({STRING:str}, {INTEGER}, 1)
    
Next

Make First Character Uppercase

IIf(Len({STRING}) > 0, UCase(Left({STRING}, 1)) & Mid({STRING}, 2), "")

String Append

{string:str} = {string:str} &  {string:str1} 

TRIM

{STRING} = Trim$({STRING})

Use Default If Empty String

If Len({STRING:str}) = 0 Then
    {STRING:str} = {STRING:Default}
Else
    {STRING:str} = {STRING:str}
End If