Term
|
Definition
| Find the ASCII code of the first character in a string. |
|
|
Term
|
Definition
| Find the character that corresponds to an ASCII code (written in denary). |
|
|
Term
|
Definition
| Find the number of characters in a string (including space characters). |
|
|
Term
| LEFT(text, number of characters) |
|
Definition
| Find the leftmost characters in a string. |
|
|
Term
| MID(text, position of first character, number of characters) |
|
Definition
| Find a number of characters starting from a certain character. |
|
|
Term
RIGHT(text, number of characters)
[Does not reverse the order of characters.] |
|
Definition
| Find the rightmost characters in a string. |
|
|
Term
TEXT(number, string format)
[The format "0.00" will return a decimal with two places. "#,##0" will return an integer with commas separating every three digits. "0%" will return a percentage. The formats must be strings enclosed by double quotes!] |
|
Definition
| Convert a number into a string in the specified format. |
|
|
Term
|
Definition
| Return the numeric value of a text string which contains numerical characters. |
|
|
Term
| CONCATENATE(text 1, text 2 ... text n) |
|
Definition
| Concatenate the strings together. |
|
|
Term
EXACT(text 1, text 2)
[This functions is case-sensitive.] |
|
Definition
| Determine whether two strings are exactly the same. |
|
|
Term
|
Definition
| Convert all uppercase characters in the string to lowercase. |
|
|
Term
|
Definition
| Convert the first character of each word in a text to uppercase, and the rest to lowercase. |
|
|
Term
|
Definition
| Remove all the spaces in a string. |
|
|
Term
|
Definition
| Convert all the lowercase characters in the string to uppercase. |
|
|
Term
FIND(substring, string, first character)
[The returned value is not relative to the third argument.] |
|
Definition
| Find the position of a substring in a string starting from a certain character. This function is case-sensitive. |
|
|
Term
SEARCH(substring, string, first character)
[The returned value is not relative to the third argument.] |
|
Definition
| Find the position of a substring in a string starting from a certain character. This function is not case-sensitive. |
|
|
