反馈已提交

网络繁忙

Text function

  • Last update：  2023-05-15

    • 1. Overview

    1.1 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
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

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

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

    不再提示

    10s后关闭