SPLIT - Splitting a Character String

  • Last update:  2023-08-22
  • Overview

    Grammar

    SPLIT(String1,String2 )

    Returns an array of character strings splited from String1 by the separator String2.

    Parameter 1

    String1

    Double-quoted string to be split

    Parameter 2

    String2

    Double-quoted separator to split String1, such as ",".

    Notes

    • Direct connect data does not support the SPLIT function.

    • The function supports two parameters of any type.

    • The function in FineBI 6.0 does not support regular expressions.

    Example

    For example, if you want to split the column "Store Name" based on the separator "store",

    enter the formula SPLIT (Store Name,"store").

    SPLIT1.png

    The column obtained after splitting is shown in the following figure.

    SPLIT2.png

    More examples:

    FormulaResultNotes
    SPLIT("hello,world,yes",",")"hello","world","yes"/
    SPLIT("this is very good"," ")"this","is","very","good"/


    Attachment List


    Theme: Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

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

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

    不再提示

    10s后关闭

    反馈已提交

    网络繁忙