Line Formatter — Add Prefix, Suffix & Join
Wrap each line with a prefix and suffix and join them with any separator, in your browser.
Items: 3
How to use
- Paste your list into the input box, one item per line.
- Set a prefix and suffix to wrap each line, and pick a separator.
- Copy the formatted result from the output box.
About this tool
ShowHide
Paste a list and reformat every line at once: wrap each one in a prefix and suffix and join them with the separator you choose. It is the fastest way to turn a column pasted out of a spreadsheet into a SQL IN list, a JavaScript array, quoted CSV values or Markdown bullets, and lines can be trimmed and blanks dropped before anything is wrapped. The wrapping is literal, which is the thing to watch: a value that already contains your quote character is not escaped, so a name like O'Brien will break a single-quoted SQL list. For that case switch the quote style or fix those rows first. Everything runs locally in your browser — nothing is uploaded.
Frequently asked questions
What can I build with this?
Common uses are SQL IN lists (prefix and suffix ' with a comma separator), JavaScript or Python array literals, quoted CSV rows, and Markdown or HTML list items.
What do the trim and remove-empty options do?
Trim removes leading and trailing whitespace from each line before wrapping. Remove empty lines drops blank lines so they don't become empty wrapped entries.
Can I use a custom separator?
Yes. Choose Custom and type any separator string, such as a space-arrow-space or a pipe. The built-in choices cover newline, comma, comma-space, space, semicolon and pipe.
Is my data sent anywhere?
No. Formatting happens entirely in your browser; nothing is uploaded.
My SQL list broke on a name like O'Brien. Why?
Because the wrapping is literal — the prefix and suffix are added as typed and nothing inside the line is escaped. A value already containing your quote character closes the string early. Switch to a quote the data does not use, or double the apostrophes in the source before pasting.
Is a long IN list a good idea?
Past a few hundred values, usually not. Databases have limits — Oracle caps IN at 1,000 items — and query plans degrade well before that. A temporary table joined to your query, or a batched query, holds up where a list of ten thousand literals will not.
Related tools
Remove Line Breaks
Join wrapped lines back into clean, flowing text — strip the hard line breaks you get when copying from PDFs or emails, while keeping real paragraphs.
Text
Word Wrap — Reflow Text to a Column Width
Hard-wrap text to a fixed line width, breaking at word boundaries, in your browser.
Text
Sort & Dedupe Lines
Sort, dedupe, trim, shuffle, or reverse a list of lines. Natural sort for embedded numbers, case-sensitive toggle, blank-line removal.
Text
Text Diff Viewer
Compare two pieces of text and see line-by-line or word-by-word additions and removals.
Text
Text Repeater
Repeat a word, line or block of text any number of times — joined by a new line, space, comma, nothing, or your own separator.
Text
Find & Replace
Find and replace across a block of text. Optional regex with global, case-insensitive, multiline, and dotAll flags. Live match count.
Text