Function String Manipulations Class

DoubleQuoteString

Surrounds a string with double-quote characters ("). Replaces each double-quote character within the string with two double-quote characters.

Signature (Visual Basic / VBA)

Public Function DoubleQuoteString( _
    ByVal vValue As Variant _
    ) As String

Code Example

    ? "Joseph (""Joe"") Marks"
    Joseph ("Joe") Marks
    ? DoubleQuoteString("Joseph (""Joe"") Marks")
    "Joseph (""Joe"") Marks"
    ? DoubleQuoteString(12345)
    "12345"

Parameters

Parameter Description
vValue The string which is to be double-quoted. vValue defaults to an empty string if it is Null or cannot be fixed up to a String.