Unicode-aware counts, reading time and platform limits
Join & Split Lines
Join lines into one with a custom delimiter (\n, tab), wrap items in quotes, drop empty and duplicate items, or split delimited text back into lines.
Workspace
Result
How the result is calculated
The input is split on line endings (LF or CRLF), then options apply in order: trim, remove empty, remove duplicates (first occurrence kept), wrap each item in the chosen mark (brackets close with their pair), then join with the delimiter. The delimiter accepts the sequences \n, \t and \r. In split mode the text is split on the delimiter literally (an empty delimiter means one character per line).
Limits:
Quotes inside items are not escaped: an item that contains
" stays as is inside the wrapping, so do not use the output directly as CSV or SQL without proper escaping.FAQ
How do I build an SQL IN list?
Wrap with ' and use “, ” as delimiter, then add parentheses around the result.
How do I use a tab delimiter?
Type \t in the delimiter field.
