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").
The column obtained after splitting is shown in the following figure.
More examples:
| Formula | Result | Notes |
|---|---|---|
| SPLIT("hello,world,yes",",") | "hello","world","yes" | / |
| SPLIT("this is very good"," ") | "this","is","very","good" | / |
Previous：STARTWITH - Determining Whether str1 Starts with str2
