| Function | Description |
|---|
TRIM | Clear all spaces at the beginning and end of the text. |
| FORMAT | Formatting of a certain data. |
| ENDWITH | Determine if str1 ends with str2. |
| NUMTO | Return the Chinese representation of the field. |
| LEFT | Returns the first or first few characters of the text string according to the specified number of characters. |
| SUBSTITUTE | Replace the specified text in the text string. |
| MID | Returns a certain number of characters in the text string starting from the specified position, the number is specified by the user. |
| EXACT | Check if the two sets of text are identical. If they are identical, the EXACT function returns TRUE; otherwise, it returns FALSE. |
| TOINTEGER | Convert text to Integer objects. |
| REPEAT | Repeats the text according to the specified number of times. |
| SPLIT | Split String. |
| UPPER | Convert all characters in the text to uppercase. |
| RIGHT | Returns the last character or characters in the text string, starting from the right, according to the specified number of characters. |
| TODOUBLE | Convert text to Double objects. |
| INDEXOF | Returns the character at the specified position in the string. |
| FIND | Returns the position of the specified character in the string. |
| REPLACE | Replaces the content in the original text with other text based on the specified string. |
| CONCATENATE | Merge several strings into a single string. |
| LOWER | Convert all uppercase letters to lowercase. |
| LEN | Returns the length of the number of characters in the text string. |
| CHAR | According to the specified number to return to the corresponding characters, CHAR function can be converted to other types of computer numeric code to characters. |
| CODE | Calculates the numeric code of the first character in the text string. The returned code corresponds to the character set used by the computer. |
| PROPER | Convert the first letter of the text and the first letter after all non-alphabetic characters to uppercase and the other letters to lowercase. |
| REGEXP | Whether the string str matches the regular expression pattern. |
| STARTWITH | Determine if str1 starts with str2. |
