Split Text by Delimiter
Split Text by Delimiter uses the entered literal separator or comma when the field is empty. Every occurrence creates a boundary; each piece is trim()ed and joined with LF. Consecutive or edge delimiters create empty output lines. There is no CSV quoting, regular expression, escape syntax, multiple-delimiter support, limit, preservation of edge whitespace, or protection for delimiters inside quoted data.
Runs locally — files stay on your deviceIs the delimiter treated as a regular expression?
No. It is a literal string.
Literal splitting has no quoting context
A delimiter inside a value is indistinguishable from a structural separator unless a parser defines quoting/escaping.
How it works
input.split(separator or ',') maps trim over parts and joins with newline.
Key concepts
Empty field means comma
It cannot request an empty-string character split.
Pieces are trimmed
Leading/trailing whitespace is lost.
When to use it
- Split a simple comma list.
- Turn one known literal token into line boundaries.
- Normalize edge spaces around plain items.
When not to use it
- Do not parse CSV or quoted values.
- Do not expect regex syntax.
- Do not expect empty pieces removed.
Worked examples
Comma
- Input
a, b,c- Expected output
a\nb\nc
Default and trim.
Multi-character
- Input
a||b; delimiter ||- Expected output
a\nb
Literal token.
Consecutive
- Input
a,,b- Expected output
a\n\nb
Empty part retained.
Common mistakes
Using for CSV
Quoted commas still split. Correction: Use a CSV parser.
Expecting regex
Characters are literal. Correction: Use regex tooling elsewhere.
Losing edge spaces
Every part trims. Correction: Choose a preserving splitter.
Best practices
- Choose an unambiguous delimiter.
- Preview empty items.
- Use a format parser for structured data.
Related operations and differences
Remove Line Numbers
Choose Remove Line Numbers when you need to strip common line-number prefixes.; use Split Text by Delimiter specifically for split delimiter.
Add Prefix to Every Line
Choose Add Prefix to Every Line when you need to add the same prefix before every line.; use Split Text by Delimiter specifically for split delimiter.
Add Suffix to Every Line
Choose Add Suffix to Every Line when you need to add the same suffix after every line.; use Split Text by Delimiter specifically for split delimiter.
Capitalize Every Word
Choose Capitalize Every Word when you need to capitalize the first character of every word.; use Split Text by Delimiter specifically for split delimiter.
Character Counter
Choose Character Counter when you need to count Unicode characters in text.; use Split Text by Delimiter specifically for split delimiter.
Extract Email Addresses
Choose Extract Email Addresses when you need to find unique email addresses in text.; use Split Text by Delimiter specifically for split delimiter.
Limitations and privacy
- One literal delimiter, comma fallback, trim and LF output; no quoting, escaping, regex, multiple delimiters, empty-item filter, split limit, or whitespace preservation.
Text is transformed locally in this browser and is not uploaded by the tool.
Frequently asked questions
What is the default delimiter?
Comma.
Are pieces trimmed?
Yes.
Are empty pieces removed?
No.
Can I use a multi-character delimiter?
Yes.