Split

Split text into a list of text segments separated by a comma or another specified delimiter.

Tip:

If there are spaces in between words separated by a comma such as This, is, an, example, then be sure to include a space after the comma as the separator so that the result set output field doesn't return spaces at the beginning of words. If spaces are included inconsistently, use the Trim function card to get rid of them.

Input

Field Definition Type Required

text

Field	Definition	Type	Required
text	Target string value that will be converted to a list. For example: `one,two,three`	String	TRUE
separator	Delimiter that determines where text will be split. This value can be any of the following: A single character, such as a comma A sequence of characters such as a comma followed by a space A line break	String	FALSE

Target string value that will be converted to a list.

For example: one,two,three

String

TRUE

separator

Delimiter that determines where text will be split. This value can be any of the following:

A single character, such as a comma
A sequence of characters such as a comma followed by a space
A line break

String

FALSE

Output

Field	Definition	Type
result list	Converted list of string values.	List of Text