String & Character Functions

ASCReturns the ANSI number for the first character in a text string (Integer).
CHRReturns the character with the corresponding ANSI number (String).
CSTRReturns the expression converted to a string datatype (String).
FORMATReturns the text string of a number or date in a particular format (String).
INSTRReturns the position of a substring within a larger string (Long).
INSTRREVReturns the position of a substring within a larger string, from the end (Long).
JOINReturns a text string containing all the elements in an array (String).
LCASEReturns the text string with all characters converted to lowercase (String).
LEFTReturns a substring from the left of a string (String).
LENReturns the number of characters in a string (Long).
LIKEThis is a pattern matching operator.
LSETLeft justifies a string within a destination and fills the remainder with spaces.
LTRIMReturns the text string without leading spaces (String).
MID - FunctionReturns a substring from the middle, left or right of a string (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 text string (String).
RSETRight aligns a string within a string variable.
RTRIMReturns the text string without trailing spaces (String).
SPACEReturns the specified number of spaces (String).
SPLITReturns an array containing a specified number of substrings (Variant).
STRReturns the text string of a number (String).
STRCOMPReturns the result of a string comparison (Integer).
STRCONVReturns the text string converted to a specific case or type (String).
STRINGReturns a repeating character of a given length (String).
STRREVERSEReturns the text string with the characters reversed (String).
TRIMReturns the text string removing leading and trailing spaces (String).
UCASEReturns the text string with all the characters converted to uppercase (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 (String).
CSTR
Returns the expression converted to a string datatype (String).
FORMAT
Returns the text string of a number or date in a particular format (String).
INSTR
Returns the position of a substring within a larger string (Long).
INSTRREV
Returns the position of a substring within a larger string, from the end (Long).
JOIN
Returns a text string containing all the elements in an array (String).
LCASE
Returns the text string with all characters converted to lowercase (String).
LEFT
Returns a substring from the left of a string (String).
LEN
Returns the number of characters in a string (Long).
LIKE
This is a pattern matching operator.
LSET
Left justifies a string within a destination and fills the remainder with spaces.
LTRIM
Returns the text string without leading spaces (String).
MID - Function
Returns a substring from the middle, left or right of a string (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 text string (String).
RSET
Right aligns a string within a string variable.
RTRIM
Returns the text string without trailing spaces (String).
SPACE
Returns the specified number of spaces (String).
SPLIT
Returns an array containing a specified number of substrings (Variant).
STR
Returns the text string of a number (String).
STRCOMP
Returns the result of a string comparison (Integer).
STRCONV
Returns the text string converted to a specific case or type (String).
STRING
Returns a repeating character of a given length (String).
STRREVERSE
Returns the text string with the characters reversed (String).
TRIM
Returns the text string removing leading and trailing spaces (String).
UCASE
Returns the text string with all the characters converted to uppercase (String).
VAL
Returns the numbers contained in a string as a numeric value of the appropriate data type (Double).

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