Function or Statement
|
Purpose
|
For More Information
|
GetField
|
Returns a substring from a delimited source string
|
|
Hex
|
Returns the hexadecimal representation of a number, as a string
|
|
InStr
|
Returns the position of one string within another
|
|
LCase
|
Converts a string to lower case
|
|
Left
|
Returns the left portion of a string
|
|
Len
|
Returns the length of a string or size of a variable
|
|
Like Operator
|
Compares a string against a pattern
|
|
LTrim
|
Removes leading spaces from a string
|
|
Mid Function
|
Returns a portion of a string
|
|
Mid Statement
|
Replaces a portion of a string with another string
|
|
Oct
|
Returns the octal representation of a number, as a string
|
|
Right
|
Returns the right portion of a string
|
|
RTrim
|
Removes trailing spaces from a string
|
|
SetField
|
Replaces a substring within a delimited target string
|
|
Space
|
Returns a string of spaces
|
|
Str
|
Returns the string representation of a number
|
|
StrComp
|
Compares two strings
|
|
String
|
Returns a string consisting of a repeated character
|
|
Trim
|
Removes leading and trailing spaces from a string
|
|
UCase
|
Converts a string to upper case
|
|