Strings & Characters Functions
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). |
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