Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_GeneralGeneral Functions

Public Function AddIfNotMt (
s As Variant,
prefix As String,
suffix As String
) As String

Add the prefix and suffix to the string if the string is not empty

s as Variant

the input string

prefix as String

text to add at the start of the string

suffix as String

text to add at the end of the string

Call Template:

Dim s As String
s = xf.Gen.AddIfNotMt(s, prefix, suffix)

See Also:

Example 1:

Dim i as Long
Dim s as String
s = ""
For i=1 To 9 : s = AddIfNotMt(s, ", ","")
Debug.Print s
prints: 1, 2, 3, 4, 5, 6, 7, 8, 9
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd