Name

Description

Asc

Returns an integer value representing the character code corresponding to a character.

AscW

Returns an integer value representing the Unicode character code corresponding to a character.

Base64Decode

Converts a base-64 encoded string to a decoded, readable string

Base64Encode

Converts a readable string to its equivalent string representation that is encoded with base-64 digits.

Char

Returns a String containing the character associated with the specified character code.

Code

Returns an integer value representing the character code corresponding to a character.

Concatenate

Return the concatenation of the string representation of the objects that are specified as the function arguments.

Decrypt

Decrypts the specified (encrypted) tekst

Encrypt

Encrypts the specified tekst

Find

Returns an integer specifying the start position of the first occurrence of findString within findIn. The integer is  a one-based index if a match is found. If no match is found, the function returns zero. This is a case-sensitive compare.

Format

Returns a string formatted according to instructions contained in a format String expression.

FormatCurrency

Returns an expression formatted as a currency value using the regional settings.

FormatDateTime

Returns a string expression representing a date/time value, using the specified NamedFormat (e.g. "GeneralDate").

FormatNumber

Returns an expression formatted as a number, using the default regional settings.

FormatPercent

Returns an expression formatted as a percentage (that is, multiplied by 100) with a trailing % character, using the default regional settings.

FormatString

Returns a string representation of the resolved fmt, using the provided args

GetEnumKey

Gets the index of the enum of the specified name. Enum values are delimited by semicolon (;)

GetEnumValue

Gets the value of the enum of the specified index. Enum values are delimited by semicolon (;)

InStr

Returns an integer specifying the start position of the first occurrence of one string within another.

InStr

Returns an integer specifying the start position of the first occurrence of one string within another.

InStrRev

Returns the position of the first occurrence of one string within another, starting from the right side of the string.

InStrRev

Returns the position of the first occurrence of one string within another, starting from the right side of the string.

Join

Returns a string created by joining a number of substrings contained in an array.

LCase

Returns a string or character converted to lowercase.

Left

Returns a string containing a specified number of characters from the left side of a string.

Len

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Len

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Len

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Len

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Len

Returns an integer containing either the number of characters in a string or the nominal number of bytes required to store a variable.

Lower

Returns a copy of this string converted to lowercase.

LSet

Returns a left-aligned string containing the specified string adjusted to the specified length.

LTrim

Returns a string containing a copy of a specified string with no leading spaces.

Mid

Returns a string that contains all the characters starting from a specified position in a string.

Mid

Returns a string that contains all the characters starting from a specified position in a string.

Parse

Parse the specified line, based on the specified startPattern (read until EndOfLine)

Parse

Parse the specified line, based on the specified startPattern and endPattern

Proper

Converts the specified string to title case (except for words that are entirely in uppercase, which are considered to be acronyms).

Replace

Returns a string in which a specified substring has been replaced with another substring a specified number of times.

Rept

Returns a string consisting of the specified string repeated the specified number of times.

Right

Returns a string containing a specified number of characters from the right side of a string.

RSet

Returns a right-aligned string containing the specified string adjusted to the specified length.

RTrim

Returns a string containing a copy of a specified string with no trailing spaces.

Search

Returns an integer specifying the start position of the first occurrence of findString within findIn. The integer is  a one-based index if a match is found. If no match is found, the function returns zero. This is a non case-sensitive compare.

Space

Returns a string consisting of the specified number of spaces.

StrComp

Returns -1, 0, or 1, based on the result of a string comparison.

StrDup

Returns a string or object consisting of the specified Character repeated the specified number of times.

StrDup

Returns a string or object consisting of the specified Character repeated the specified number of times.

StrReverse

Returns a string in which the character order of a specified string is reversed.

Text

Returns a string that represents the specified object.

Text

Returns a string that represents the specified integer, using the specified culture string (e.g. "en-GB")

Text

Returns a string that represents the specified integer, using the default culture info

Text

Returns a string that represents the specified double, using the specified culture string (e.g. "en-GB")

Text

Returns a string that represents the specified double, using the default culture info

Text

Returns a string representation of the specified date, using the specified format, and the specified culture string (e.g. "en-GB")

Text

Returns a string representation of the specified date, using the default format d-MMM-yyyy, and the default culture info.

Text

Returns a string representation of the specified date, using the specified format, and the default culture info.

Trim

Returns a string containing a copy of a specified string with no leading or trailing spaces.

UCase

Returns a string or character containing the specified string converted to uppercase.

Upper

Returns a copy of this string converted to uppercase.

Value

Convert the specified tekst to a value, using the default culture info. Order is Date, Integer, Double.

Value

Convert the specified tekst to a value, using the specified culture string (e.g. "en-GB"). Order is Date, Integer, Double.



Back to Function reference