String Functions

FunctionDescription
InStrReturns the position of the first occurrence of one string within another. The search begins at the first character of the string.
InStrRevReturns the position of the first occurrence of one string within another. The search begins at the last character of the string.
LeftReturns a specified number of characters from the left side of a string
LenReturns the number of characters in a string
LTrimRemoves spaces on the left side of a string
RTrimRemoves spaces on the right side of a string
TrimRemoves spaces on both the left and the right side of a string
MidReturns a specified number of characters from a string
ReplaceReplaces a specified part of a string with another string for a specified number of times
RightReturns a specified number of characters from the right side of a string
SpaceReturns a string that consists of a specified number of spaces
StrCompCompares two strings and returns a value that represents the result of the comparison
StrReverseReverses a string
LCaseConverts a specified string to lowercase
UCaseConverts a specified string to uppercase