Function

split( text, separator )

Splits text into a list of text elements, delimited by the text specified in the separator.

Parameters

Returns

Text

Examples

Splitting text into text elements

1
split("John Smith", "m")

Returns { "John S", "ith" }.

Splitting a sentence into words

1
split("A sentence has words separated by spaces.", " ")

Returns { "A", "sentence", "has", "words", "separated", "by", "spaces." }.

Splitting raw data into record fields

1
2
3
4
5
6
7
a!localVariables(
  local!names: "James Cameron; Sofia Coppola",
  a!forEach(
    split(local!names, "; "),
    recordType!Person(Person.name: fv!item)
  )
)

Returns { [Person name=James Cameron], [Person name=Sofia Coppola] }.

Lists

Splitting multiple text values

1
split({ "carol@sample.com", "jeremy@sample.com" }, "@")

Returns { "carol", "sample.com", "jeremy", "sample.com" }. All items in the list are processed together.

Splitting with multiple separators

1
split("REDXbluexGREEN", { "x", "X" })

Returns { "RED", "blue", "GREEN" }. All separators in the list are used to separate elements. Any matching separator results in a split regardless of their order in the text or the separator list.

Feature compatibility