Strings & Characters Functions

ASCReturns the ANSI number for the first character in a text string (Integer).
CHRReturns the character with the corresponding ANSI number (Variant / String).
CSTRReturns the expression converted to a string data type (String).
FORMATReturns the text string of a number or date in a particular format (Variant / String).
INSTRReturns the position of a substring within a larger string (Long).
INSTRREVReturns the position of a substring within a larger string, starting at the end (Long).
LCASEReturns the text string with all characters converted to lowercase (Variant / String).
LEFTReturns a number of characters from the left of a string (Variant / String).
LENReturns the number of characters in a string (Long).
LSETLeft aligns a string within a string variable.
LTRIMReturns the text string without leading spaces (Variant / String).
MID - FunctionReturns the text string which is a substring of a larger string (Variant / String).
MID - StatementReplaces a specified number of characters with characters from another string.
REPLACEReturns the text string with a number of characters replaced (String).
RIGHTReturns a number of characters from the right of a string (Variant / String).
RSETRight aligns a string within a string variable.
RTRIMReturns the text string without trailing spaces (Variant / String).
SPACEReturns the specified number of spaces (Variant / String).
STRReturns the text string of a number (Variant / String).
STRCOMPReturns the result of a string comparison (Integer).
STRCONVReturns the text string converted to a specific case or type (Variant / String).
STRINGReturns a repeating character of a given length (Variant / String).
STRREVERSEReturns the text string with the characters reversed (Variant / String).
TRIMReturns the text string without leading and trailing spaces (Variant / String).
UCASEReturns the text string with all the characters converted to uppercase (Variant / String).
VALReturns the numbers contained in a string as a numeric value of the appropriate data type (Double).
ASC
Returns the ANSI number for the first character in a text string (Integer).
CHR
Returns the character with the corresponding ANSI number (Variant / String).
CSTR
Returns the expression converted to a string data type (String).
FORMAT
Returns the text string of a number or date in a particular format (Variant / String).
INSTR
Returns the position of a substring within a larger string (Long).
INSTRREV
Returns the position of a substring within a larger string, starting at the end (Long).
LCASE
Returns the text string with all characters converted to lowercase (Variant / String).
LEFT
Returns a number of characters from the left of a string (Variant / String).
LEN
Returns the number of characters in a string (Long).
LSET
Left aligns a string within a string variable.
LTRIM
Returns the text string without leading spaces (Variant / String).
MID - Function
Returns the text string which is a substring of a larger string (Variant / String).
MID - Statement
Replaces a specified number of characters with characters from another string.
REPLACE
Returns the text string with a number of characters replaced (String).
RIGHT
Returns a number of characters from the right of a string (Variant / String).
RSET
Right aligns a string within a string variable.
RTRIM
Returns the text string without trailing spaces (Variant / String).
SPACE
Returns the specified number of spaces (Variant / String).
STR
Returns the text string of a number (Variant / String).
STRCOMP
Returns the result of a string comparison (Integer).
STRCONV
Returns the text string converted to a specific case or type (Variant / String).
STRING
Returns a repeating character of a given length (Variant / String).
STRREVERSE
Returns the text string with the characters reversed (Variant / String).
TRIM
Returns the text string without leading and trailing spaces (Variant / String).
UCASE
Returns the text string with all the characters converted to uppercase (Variant / String).
VAL
Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).

© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top