Text

Text

Name	Syntax	Description
Chr	Chr(65)	Returns the character associated with the specified ANSI character code.
InStr	InStr(HAYSTACK, NEEDLE)	Returns an integer specifying the start position of the first occurrence of one string (NEEDLE) within another (HAYSTACK).
InStrRev	InStrRev(HAYSTACK, NEEDLE)	Returns the position of the first occurrence of one string (NEEDLE) within another (HAYSTACK), starting from the right end of the string.
Lcase	Lcase(STRING)	Returns a string or character converted to lower case.
Left	Left(STRING, LENGTH)	Returns a string containing a specified number of characters from the left end of a string.
Len	Len(STRING)	Returns an integer containing the number of characters in a string.
Right	Right(STRING, LENGTH)	Returns a string containing a specified number of characters from the right end of a string.
Split	Split(STRING, DELIMITER)	Returns a zero-based, one-dimensional array containing a specified number of substrings. The specified delimiter is used to create the substrings.
LTrim , RTrim , Trim	Trim(STRING)	Returns a string containing a copy of a specified string with no leading spaces (LTrim), no trailing spaces (RTrim), or neither leading nor trailing spaces (Trim).
FormatDateTime	FormatDateTime(DATE, FORMAT)	Returns a string expression representing a date/time value in a specified format. The following formats are available (used without quotes, not case-sensitive): DateFormat.GeneralDate or 0: Displays a date and/or time. If there is a date part, it is displayed as a short date. If there is a time part, it is displayed as a long time. If present, both parts are displayed. DateFormat.LongDate or 1: Displays a date using the long date format specified in your computer's regional settings. DateFormat.ShortDate or 2: Displays a date using the short date format specified in your computer's regional settings. DateFormat.LongTime or 3: Display a time using the time format specified in your computer's regional settings. DateFormat.ShortTime or 4: Displays a time using the 24-hour format (hh:mm).
FormatNumber	FormatNumber(DATE, DIGITSAFTERDECIMAL, LEADINGDIGIT, PARENS, GROUP)	Returns an expression formatted as a number. You can use the following parameters, or use blanks for the default settings: DIGITSAFTERDECIMAL: Numeric value, indicates how many places are displayed to the right of the decimal. Default: -1, the computer's regional settings are used. LEADINGDIGIT: True or False, indicates whether a leading 0 is displayed for fractional values. The computer's regional settings are used by default. PARENS: True or False, indicates whether to place negative values within parentheses. The computer's regional settings are used by default. GROUP: True or False, indicates whether or not to group numbers using the group delimiter specified in the locale settings. The computer's regional settings are used by default.
FormatPercent	FormatPercent(NUMBER)	Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character.
Mid	Mid(STRING, START, LENGTH)	Returns a string containing a specified number of characters from a string. START defines the starting position of the characters to be returned.
Ucase	UCase(STRING)	Returns a string or character containing the specified string converted to uppercase.