Split Fields

Description: Split a field in to two or more fields.
Available Filters: All Events, Event Type, Event Field.
All Fields, Field Name, Field Value.
Settings: Delimiter: The regular expression used to find the string around which the field will should be split.
- To specify a regular expression special character as delimiter, escape it using . For example to use $ as a delimiter in Donald$Duck specify \$ as the delimiter.
- Trailing empty strings are discarded. For example, in the case of wonder_women_ with _ as delimiter, the output is "wonder", "women" instead of "wonder", "women",.
Create fields from values: If selected, the returned array of strings after splitting is converted into separate fields in the Event.
Transformation Considerations: None.

Sample Transformation

Filters:
Event Type = Student.Sheet1.
Fields = All fields with name = Student Name.

Settings:
Delimiter = Comma. Create fields from values = Select this to create a new field for each value.

The settings appear as follows:

Split fields settings

Results:
The output is modified as follows if the Create fields from value check box is selected:

Split fields into new fields

The output is modified as follows if the Create fields from value check box is NOT selected:

Split fields


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-10-2022 NA Created as a new document.
Last updated on 29 Nov 2022

Tell us what went wrong