About Delimited String → Lines
Delimited String → Lines splits a single delimited string into a list, one item per line. Choose from common delimiters — comma, semicolon, pipe, tab, space, custom — and the tool emits each segment between delimiters as its own line. The original delimiter character is removed from the output.
Reach for it whenever you have a one-line value that should really be many: a comma-separated string copied out of a log line, an SQL `IN` clause, an env-var value with multiple paths, a CSV cell that holds a sub-list, or a JSON-array-as-text. Once each item is on its own line, the rest of the list toolbox composes naturally — sort, dedupe, filter, trim, or join with a different delimiter. This tool is the inverse of Lines → Delimited String: feeding the output of one into the other returns the original input as long as items do not themselves contain the delimiter.
Examples
apple, banana, cherry, dateapple
banana
cherry
dateSplitting on `,`. Each segment becomes its own line; whitespace is preserved — run Trim Each Line afterwards if your delimiter is `, ` rather than `,`.
Frequently asked questions
What if the delimiter has whitespace around it (`, ` instead of `,`)?
Splitting on `,` leaves a leading space on every item except the first. Either set the delimiter explicitly to `, ` (comma plus space), or split on `,` and run Trim Each Line afterwards.
Will it handle CSV-style quoted fields with embedded commas?
No. This tool does a literal split on the delimiter character — it does not understand quoting. For real CSV with quoted fields, use the dedicated CSV ↔ JSON tool elsewhere on the site, then convert from there.
How is this different from Filter Lines by Regex?
Filter Regex chooses which lines stay; this tool turns one line into many. They run on different sides of the line/string boundary and are usually composed together — split first, then filter.
Does it round-trip with Lines → Delimited String?
Yes when no item contains the delimiter. The two are exact inverses on well-formed input.