String Function:
Len: Returns the number of characters in a string or the number of bytes required to store a variable.
Len(str)
LCase: Returns a string that has been converted to lowercase.
Ucase: Returns a string that has been converted to uppercase.
Left: Returns a specified
number of characters from the left side of a string.
Left(str,Length)
Right: Returns a specified
number of characters from the right side of a string.
Right(str,Length)
Mid: Returns a specified
number of characters from a string.
Mid(txt,start,[length])
Replace: Replaces string with another string
Replace(expression, find, replacewith[, start[,
count[, compare]]])
Space: Returns a string
consisting of the specified number of spaces.
Space (number)
Split: Returns a zero-based,
one-dimensional array containing a specified number of substrings.
Split(expression[,delimiter[,count[,compare]]])
StrComp: Returns a value
indicating the result of a string comparison.
StrComp(string1,string2[,compare])
StrReverse: Returns a string in
which the character order of a specified string is reversed.
strReverse(string)
LTrim; RTrim; and
Trim: Returns a copy of a
string without leading spaces (LTrim), trailing spaces (RTrim), or both leading
and trailing spaces (Trim).
Trim(str)
LTrim(str)
RTrim(str)
InStr: Returns the position
of the first occurrence of one string within another.
InStr([start,]string1,string2[,compare])
InStrRev: Returns the position of an occurrence of one string within another, from the end of string.
InStrRev(string1,string2[,start[,compare]])
Array Functions:
IsArray: Returns a Boolean value
indicating whether a variable is an array.
IsArray(variable)
UBound: Returns the largest
available subscript for the indicated dimension of an array.
UBound(arrayname[,dimension])
Join - The Join function returns a string that consists of a number of substrings in an array.
Join(list[,delimiter])