FlowEngine Data Standardize & CleanInstall

Summary

Split a text field into either an array of values or a key-value object based on specified delimiters, saving the result into a chosen output field.

Inputs

• Text Field (required) — The field containing the text to split.
• Split Mode (required) — Defines how to split the text: into an array or into key-value pairs.
• Delimiters — For 'To Array' mode, characters each used as delimiters to split the text.
• Pair Delimiter — For 'To Key-Value Pairs' mode, delimiter between key-value pairs; leave empty to split on newline or semicolon.
• Key-Value Delimiter — For 'To Key-Value Pairs' mode, delimiter between key and value; leave empty to accept colon, equals, or arrow.
• Output Field (required) — Field name where the split result will be saved.
• Options — Additional options including case insensitive field matching, continue on fail, debug mode, skipping unchanged items, and tracking changes.

Output shape

A list of items with JSON data, each containing the original data plus a new field set to the split result (array or object).

If the specified text field is missing or not a string, the item is included with no changes (optionally tracked if debug or change tracking is enabled). The output includes optional internal fields (_changes, _debug) if corresponding options are enabled. Processing continues on failure if configured.

Examples

Example 1: Split a comma, semicolon, or pipe separated string in field 'data' into an array saved as 'splitResult'.

Set Text Field to 'data', Split Mode to 'To Array', Delimiters to ',;|', Output Field to 'splitResult'.

Example 2: Parse a semicolon-separated list of key-value pairs in field 'text' into an object saved as 'splitResult'.

Set Text Field to 'text', Split Mode to 'To Key-Value Pairs', Pair Delimiter to ';', Key-Value Delimiter to ':', Output Field to 'splitResult'.