CSV/Text Delimiting – Enquote string
Wraps a string in a specified delimiter and escapes any existing delimiters within the text.
This function is commonly used for generating CSV or other delimited formats where embedded delimiters must be escaped.
VB
Public Function Enquote(Text As String,
Optional Delimiter As String = """") As String
Return Delimiter + Text.Replace(Delimiter, Delimiter + Delimiter) + Delimiter
End Function