SPLIT

Divides the input text into an array using the delimiter as a separator

Syntax 

SPLIT(text, delimiter)

Usage examples 

Example 1

Input

1
{
2
"my_action": {
3
"message": "one,two,three,four,five"
4
}
5
}

Formula

SPLIT(my_action.message, ",")

Output

1
[
2
"one",
3
"two",
4
"three",
5
"four",
6
"five"
7
]
Was this helpful?