Text

**Table:** 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.

11-Jul-2025