Worked example
Before
red, green, blueAfter
red
green
blueEach comma becomes a line boundary and default trimming removes the following spaces.
Exactly what this changes
- The default finds every comma and creates a new line at that position. Values are trimmed by default, which removes surrounding whitespace from each piece but leaves internal spaces and all other characters untouched.
- This operation is intentionally not a quoted CSV parser. Quote marks have no structural meaning, so a comma inside a quoted-looking value still splits the text. The workspace always shows a concise reminder of this limitation.
- Empty pieces can be kept or dropped. They occur when delimiters are adjacent or appear at an edge. Keeping them produces explicit blank lines; dropping them removes only those zero-length results after optional trimming.
Options and edge cases
- Choose comma, semicolon, tab, or a custom delimiter of one to four characters. The custom value is matched literally and is never compiled or interpreted as a regular expression.
- Turn trimming off when spaces adjacent to delimiters are meaningful data. The keep-empty setting is evaluated after trimming, so a spaces-only value becomes empty when trimming is enabled.
Edge case: Use this splitter only for simple delimiter text. Escaped quotes, multiline quoted fields, and embedded delimiters require a standards-compliant CSV parser and are outside this operation.