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
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
Returns a WString of one or more characters from their Unicode Integer representation.

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
Returns a formatted String representation of a Double.

String to Numeric Conversions
VAL
Returns the Double conversion of a numeric string.
VALINT
Returns the Integer conversion of a numeric string.
VALLNG
Returns the Long conversion of a numeric string.
VALUINT
Returns the uInteger conversion of a numeric string.
VALULNG
Returns the ULong conversion of a numeric string.

Numeric Serialization
MKD
Returns an eight character String representation of a Double.
MKI
Returns a four character String representation of a Integer.
MKL
Returns a four character String representation of a Long.
MKLONGINT
Returns an eight character String representation of a Longint.
MKS
Returns a four character String representation of a Single.
MKSHORT
Returns a two character String representation of a Short.
CVD
Returns a Double representation of an eight character String.
CVI
Returns an Integer representation of a four character String.
CVL
Returns a Long representation of a four character String.
CVLONGINT
Returns a Longint representation of an eight character String.
CVS
Returns a Single representation of a four character String.
CVSHORT
Returns a Short representation of a two character String.

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
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki



sf.net phatcode