String Functions
Statements and Procedures that work with strings.
Description:
These statements and procedures provide many ways to create and manipulate strings and substrings. Numbers can be converted to strings and vice-versa. Procedures are also provided to aid in serialization of numeric data, perhaps for persistent storage.
Creating Strings
String data types and procedures that create new strings.
Character Conversions
Procedures that convert from character codes to strings and back.
Numeric/Boolean to String Conversions
Procedures that convert numeric values to strings.
String to Numeric Conversions
Procedures that convert strings to numeric values.
Numeric Serializations
Procedures that convert raw numeric data to and from strings suitable for storage.
Working with Substrings
Procedures that return subsets of strings, or that modify subsets of strings.
Creating Strings
Character Conversion
Numeric/Boolean to String Conversions
String to Numeric Conversions
STRING
Standard data type: 8 bit character string.
STRING (Function)
Returns a String of multiple characters.
ZSTRING
Standard data type: null terminated 8 bit character string.
WSTRING
Standard data type: wide character string.
WSTRING (Function)
Returns a WString of multiple characters.
SPACE
Returns a String consisting of spaces.
WSPACE
Returns a WString consisting of spaces.
LEN
Returns the length of a string in characters.
Character Conversion
ASC
Returns an Integer representation of an character.
CHR
Returns a string of one or more characters from their ASCII Integer representation.
WCHR
Numeric/Boolean to String Conversions
BIN
Returns a binary String representation of an integral value.
WBIN
Returns a binary WString representation of an integral value.
HEX
Returns a hexadecimal String representation of an integral value.
WHEX
Returns a hexadecimal WString representation of an integral value.
OCT
Returns an octal String representation of an integral value.
WOCT
Returns an octal WString representation of an integral value.
STR
Returns the String representation of numeric value or boolean.
WSTR
Returns the WString representation of numeric value.
FORMAT
String to Numeric Conversions
Numeric Serialization
Working with Substrings
Working with Substrings
LEFT
Returns a substring of the leftmost characters in a string.
MID (Function)
Returns a substring of a string.
RIGHT
Returns a substring of the rightmost characters in a string.
LCASE
Returns a copy of a string converted to lowercase alpha characters.
UCASE
Returns a copy of a string converted to uppercase alpha characters.
LTRIM
Removes surrounding substrings or characters on the left side of a string.
RTRIM
Removes surrounding substrings or characters on the right side of a string.
TRIM
Removes surrounding substrings or characters on the left and right side of a string.
INSTR
Returns the first occurrence of a substring or character within a string.
INSTRREV
Returns the last occurrence of a substring or character within a string.
MID (Statement)
Copies a substring to a substring of a string.
LSET
Left-justifies a string.
RSET
Right-justifies a string.
Back to Table of Contents