历史版本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 |