Prefix / Suffix Wrapper
Wrap every line with a custom prefix and suffix. Useful for building SQL IN clauses ('value'), quoting shell arguments, wrapping HTML tags, or generating code from a list.
How to use the prefix / suffix wrapper
Set a prefix and a suffix; every line gets wrapped. Useful for SQL IN clauses, code generation, or quoting lists.
Formula & explanation
Pure string concatenation; no escaping is performed — that's your responsibility for the target context.
Examples
Prefix ' and suffix ', → SQL list: 'apple', 'banana', 'cherry',
Frequently asked questions
- How do I format a list for a SQL IN clause?
- Set prefix to ' and suffix to ', then paste your values. Copy the result and paste inside IN ( … ).
- Can I add a prefix without a suffix, or vice versa?
- Yes — leave either field blank and only the non-empty side is added to each line.
- Does the tool escape quotes or special characters?
- No, it is pure string concatenation. If your values contain single quotes, escape them manually before pasting.
- What is 'Skip blank lines' for?
- It prevents blank lines in your input from becoming lines with only the prefix/suffix, keeping the output clean.
Related list tools tools
- List FilterKeep or remove lines matching a plain-text substring or regular expression. Useful for filtering log output, cleaning data, or extracting matching lines from large lists.
- Comma to Lines ConverterConvert between comma-separated values and one-item-per-line format. Handles quoted fields, trims whitespace, and removes duplicates. Paste CSV data, get a clean list — and back.
- Number Sequence GeneratorExpand range patterns like 1..100 or 0,2,4..20 into complete numeric lists. Supports step size, comma-separated output, and custom separators — great for test data and scripting.
- List StatsGet statistics on any list: total count, unique count, min and max line length, average length, and the longest and shortest items. Useful for auditing data before further processing.
- List to JSON ArrayConvert a one-item-per-line list into a JSON array of strings and back again. Handles quoting and escaping automatically — useful for turning clipboard lists into API payloads.
- List Set OperationsPerform set operations on two lists: union, intersection, difference, A-only, B-only, and symmetric difference. Paste two lists and choose the operation — results update instantly.