历史版本53 :文本函数概述 返回文档
编辑时间:
内容长度:图片数:目录数:
修改原因:
1. Overview编辑
1.1 Version
| FineBI | JAR | Function Changes |
|---|---|---|
| 5.1 | - | - |
| 5.1.7 | 2020-11-05 | Function interpretation optimization clarify function parameter legality |
| 5.1.11 | 2021-04-02 | Real-time data formula verification enhancement |
| 5.1.12 | - | Sampling data formula calibration enhancement |
1.2 Use location
| Use location | |
|---|---|
| Self-service dataset | Add new column、Filter |
| Dashboard | Add calculated fields |
2. Function list编辑
| Function | Description |
|---|---|
| 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 |