反馈已提交

网络繁忙

You are viewing 5.1 help doc. More details are displayed in the latest help doc.

Text function

  • Recent Updates: April 08, 2022

    • 1. Overview

    1.1 Version

              FineBI Version         JAR PackageFunction Changes
      5.1-
    		-
    5.1.72020-11-05
    		Function interpretation optimization & clarify function parameter legality
    5.1.112021-04-02Real-time data formula verification enhancement
    5.1.12-Sampling data formula calibration enhancement

    1.2 Scope of use


    		Location of use
    Self-Service datasetNew columns、Filter
    DashboardAdd calculation fields

    2. Function list

    FunctionDescription

    TRIM

    		Clear all spaces at the beginning and end of the text.
    FORMATFormatting of a certain data.
    ENDWITHDetermine if str1 ends with str2.
    NUMTOReturn the Chinese representation of the field.
    LEFTReturns the first or first few characters of the text string according to the specified number of characters.
    SUBSTITUTEReplace the specified text in the text string.
    MIDReturns a certain number of characters in the text string starting from the specified position, the number is specified by the user.
    EXACTCheck if the two sets of text are identical. If they are identical, the EXACT function returns TRUE; otherwise, it returns FALSE.
    TOINTEGERConvert text to Integer objects.
    REPEATRepeats the text according to the specified number of times.
    SPLITSplit String.
    UPPERConvert all characters in the text to uppercase.
    RIGHTReturns the last character or characters in the text string, starting from the right, according to the specified number of characters.
    TODOUBLEConvert text to Double objects.
    INDEXOFReturns the character at the specified position in the string.
    FINDReturns the position of the specified character in the string.
    REPLACEReplaces the content in the original text with other text based on the specified string.
    CONCATENATEMerge several strings into a single string.
    LOWERConvert all uppercase letters to lowercase.
    LENReturns the length of the number of characters in the text string.
    CHARAccording to the specified number to return to the corresponding characters, CHAR function can be converted to other types of computer numeric code to characters.
    CODECalculates the numeric code of the first character in the text string. The returned code corresponds to the character set used by the computer.
    PROPERConvert the first letter of the text and the first letter after all non-alphabetic characters to uppercase and the other letters to lowercase.
    REGEXPWhether the string str matches the regular expression pattern.
    STARTWITHDetermine if str1 starts with str2.


    Attachment List


    Theme： Advanced Data Analyis
    Already the First
    Already the Last
    • Helpful
    • Not helpful
    • Only read

    售前咨询电话

    400-811-8890转1

    在线技术支持

    在线QQ：800049425

    热线电话：400-811-8890转2

    总裁办24H投诉

    热线电话：173-1278-1526

    文 档反 馈

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭