What this tool does to each line
Every line becomes prefix + line + suffix. Nothing else is modified: the original text is not trimmed, and both strings are inserted literally, including any spaces you type. A single checkbox, "Skip empty lines", leaves lines that are empty or contain only whitespace untouched; it is on by default, so blank separators do not turn into stray ', fragments.
Recipes that work
| Goal | Prefix | Suffix | Result for the line red |
|---|---|---|---|
| Quoted, comma-separated values | ' | ', | 'red', |
| JSON-style strings | " | ", | "red", |
| HTML list items | <li> | </li> | <li>red</li> |
| Markdown bullets | - | empty | - red |
| Code comments | // | empty | // red |
| Email quoting | > | empty | > red |
| Indent with spaces | four spaces | empty | red |
Worked example: a SQL IN list
Paste three codes on separate lines (A100, B200, C300), use ' as the prefix and ', as the suffix, and the output is:
'A100',
'B200',
'C300',The tool puts the suffix on every line, so the final line also ends in a comma. Delete that last comma by hand before pasting the list into WHERE code IN (...), or the query will fail with a syntax error. If you would rather have all the values on one line, join them afterwards with Remove Line Breaks.
Limits worth knowing
- No escape sequences. Typing
\tor\nin the prefix inserts a literal backslash and letter, not a tab or line break. To insert a real tab, paste a tab character into the field. - No escaping of the content. If a line already contains a quote or apostrophe, such as
O'Brien, wrapping it in single quotes produces broken SQL or code. Escape those first with Find and Replace. - Different strings per line need another tool. The same prefix goes on every line; for a changing counter use Add Line Numbers.
- A trailing empty line, from a final line break in your paste, is skipped by default; if you turn skipping off, it receives the prefix and suffix alone.
For working with spreadsheet exports, pair this with the CSV column extractor to pull a single column first, then wrap each value.