FlowEngine Data Standardize & CleanInstall

Summary

Split a text field from input items into either an array or an object of key-value pairs based on configurable delimiters, and save the result to a specified output field.

Inputs

• Text Field (required) — The field in the input JSON containing the text to split.
• Split Mode (required) — Choose to split text either into an array of values ('To Array') or parse text into an object of key-value pairs ('To Key-Value Pairs').
• Delimiters — For 'To Array' mode, specify characters used as delimiters; each character acts as a separate delimiter (default is comma, semicolon, or pipe).
• Pair Delimiter — For 'To Key-Value Pairs' mode, delimiter between key-value pairs. Leave empty to use newline or semicolon by default.
• Key-Value Delimiter — For 'To Key-Value Pairs' mode, delimiter between key and value. Leave empty to use colon, equals, or arrow by default.
• Output Field (required) — The field name to store the split result in each output JSON object.
• Options — Additional options including tracking changes, continuing on failure, skipping unchanged items, case-insensitive field matching, and debug mode.

Output shape

a list of items, each containing the original item JSON extended with the output field holding the split results (array or key-value object).

If the input text field is missing or not a string, the item will be included with no changes except optional tracking info. When enabled, _changes and _debug fields provide detailed information about modifications and processing steps. Pagination is not applied; all input items processed at once.

Examples

Example 1: Split a comma-separated list in field 'data' into an array stored in field 'splitResult'

Text Field='data', Split Mode='To Array', Delimiters=',;|', Output Field='splitResult'

Example 2: Parse key-value pairs from text field 'data' separated by semicolons and colons

Text Field='data', Split Mode='To Key-Value Pairs', Pair Delimiter=';', Key-Value Delimiter=':', Output Field='splitResult'