Parsing
Delimited to Rows
Gives each item of a list held in one cell — "red; large; sale" — its own row, copying the rest of the row onto each.
When to use it
Use it for multi-value fields such as tags, categories or email lists, before counting, joining or de-duplicating the items.
In a pipeline
File InputDelimited to RowsSummarize (Multi-Aggregate)
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Column | select | Yes | Select column… |
| Delimiter | text | — | , |
| Trim spaces around each item | checkbox | — | true |
Example
Tags, one per row
- Column=Tags
- Delimiter=;
| Order | Tags |
|---|---|
| A-1 | red; large |
| A-2 | blue |
| Order | Tags |
|---|---|
| A-1 | red |
| A-1 | large |
| A-2 | blue |
Worth knowing
- Type \t (or tab) for a tab and \n (or newline) for a line break; a blank delimiter means a comma.
- Empty items ("a;;b") are skipped, and a row with nothing to split is kept once with a blank.
- The node refuses to make more rows than the server's row limit, before doing any work.
- To split into columns instead of rows, use Split Column.