split_string(input: text|category, {
    "param": value,
    ...
}) -> (output_left: text, output_right: text)

The values of a text column will be split in two at the first occurrence of a given pattern, returning two new text columns. For example, splitting a text column on the comma character (”,”) will produce two new columns: the first containing everything before the first comma encountered in each text, and the second containing all text encountered after the comma.

If the specified split pattern was not encountered in any of the input texts, the first output column will contain the original text, and the second column will contain missing values only (NaN).

split_string(input: text|category, {
    "param": value,
    ...
}) -> (output_left: text, output_right: text)
​
pattern
string
default:" "

A pattern of characters indicating where to split each text. By default uses the whitespace ” ”.

​
right
boolean

Whether to search for the pattern starting from the right instead of starting from the left (default).

Was this page helpful?

Suggest edits