Strings & Characters Functions

ASCReturns the ASCII / ANSI number for the first character in a text string (Integer).
ASCWReturns the Unicode number for the first character in a text string (Integer)
CHRReturns the character with the corresponding ASCII / ANSI number (Variant / String).
CHRWReturns the character with the corresponding Unicode 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 substring 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 a substring from the middle, left or right of a 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 substring 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 first number contained in a string (Double).
ASC
Returns the ASCII / ANSI number for the first character in a text string (Integer).
ASCW
Returns the Unicode number for the first character in a text string (Integer)
CHR
Returns the character with the corresponding ASCII / ANSI number (Variant / String).
CHRW
Returns the character with the corresponding Unicode 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 substring 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 a substring from the middle, left or right of a 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 substring 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 first number contained in a string (Double).

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