[SPLIT] The function splits a text string from an attribute using a specified delimiter and returns one of the resulting segments. The segment to be returned is determined by a zero-based index.
Syntax
The syntax is:
[SPLIT;[Attribute];Delimiter;0]
-
Attribute: The attribute containing the value to be split (e.g.,
[first name]). -
Delimiter: The character used to separate the string. If using a space, this field can be left blank.
Use Case
Get the First Name
This example shows how to extract the first part of a given name that contains a space.
-
Input
[first name]:Anne Mette -
Expression:
[SPLIT;[first_name]; ;0] -
How It Works: The function splits the
first nameseparated by a space character and returns the first segment (at index0). -
Output:
Anne
Get the Last Name
This example shows how to extract the last name from a full name string.
-
Input
[DisplayName]:Anne Mette Olsen -
Expression:
[SPLIT;[DisplayName]; ;2] -
How It Works: The function splits the
DisplayNameseparated by a space and returns the third segment (at index2). -
Output:
Olsen