Logo
Home Cart [Log In] About Us Contact Us

Object Reference

xf_GeneralGeneral Functions

Public Function FormatName (
fmt_str As String,
Surname,
FirstName,
Optional Title = Null,
Optional MiddleName = Null
) As String

Provides flexible formatting of title and first, middle and surnames.
Use a format string with the following values: t / T - Title (upper or lower case) f / F - First Name (upper or lower case) s / S - Surname (upper or lower case) m / M - Middle Name (upper or lower case)

fmt_str as String

The format string

Surname as Variant

(no description)

FirstName as Variant

(no description)

Optional Title as Variant = Null

(no description)

Optional MiddleName as Variant = Null

(no description)

Call Template:

Dim s As String
s = xf.Gen.FormatName(fmt_str, Surname, FirstName)
s = xf.Gen.FormatName(fmt_str, Surname, FirstName, Title, MiddleName)

See Also:

Example 1:

FormatName("S, f", "Smith", "Joseph", "Mr", "Reginald")      => "SMITH, Joseph"
FormatName("t f m s", "Smith", "Joseph", "Mr", "Reginald")   => "Mr Joseph Reginald Smith"
Contact Us :: About Us :: Policies :: email: infspamo@arrospamw-of-tispamme.com    © 2012 Arrow Of Time Pty Ltd