Jump to a tool

Text CleanerBuild a reusable cleanup pipeline for untidy text and lists.Remove Duplicate LinesDeduplicate lines while controlling case, whitespace, order, and blanks.Remove Empty LinesDelete blank rows or collapse them while preserving paragraph structure.Trim WhitespaceRemove unwanted leading or trailing whitespace with indentation control.Remove Extra SpacesNormalize repeated spaces, tabs, and non-breaking spaces safely.Sort LinesSort text alphabetically, naturally, numerically, or by length.Add Prefix and SuffixWrap, number, or punctuate every line with practical presets.Delimiter ConverterConvert lists between lines, commas, tabs, pipes, and custom separators.Compare Two ListsFind unique, shared, and duplicated items across two lists.Find and ReplaceReplace plain text or guarded regular-expression matches.

Formatting and conversion

Add Prefix and Suffix

Turn a plain list into ready-to-paste code, SQL, paths, or numbered text.

Processed locally in your browser. Your data is never uploaded or stored.
Processed locally in your browser. Your data is never uploaded or stored.

Ready

Input0 lines · 0 characters
Output0 lines · 0 characters
OptionsAdjust how this tool processes your text
Add Prefix and Suffix options
Common presetsStart with a practical format
Press Ctrl/Cmd + Enter to process

Keep tidying

Formatting and conversionDelimiter Converter

Convert lists between lines, commas, tabs, pipes, and custom separators.

Open tool →Lists and comparisonSort Lines

Sort text alphabetically, naturally, numerically, or by length.

Open tool →Text cleanupText Cleaner

Build a reusable cleanup pipeline for untidy text and lists.

Open tool →

What this tool does

A focused tool for a specific cleanup job

Add Prefix and Suffix decorates each line without editing values one by one. Built-in presets cover common code and data formats, while custom fields handle any wrapper.

Common use cases

  • Prepare values for an SQL IN clause
  • Build a JavaScript string array
  • Add URL path markers
  • Create a numbered checklist

How to use Add Prefix and Suffix

  1. Paste one value per line.
  2. Enter a custom prefix and suffix or choose a preset.
  3. Enable numbering, quoting, or punctuation as needed.
  4. Choose whether empty lines should also be changed.

Options explained

  • Numbering is inserted before the custom prefix.
  • Quote mode escapes matching quote characters inside values.
  • Comma or semicolon punctuation is appended after the suffix.
  • Empty lines are skipped unless explicitly enabled.

Example

Before
alpha
beta
After
'alpha',
'beta',

Edge cases and limitations

  • Preset output may still need an outer bracket or SQL parentheses.
  • Embedded quote characters are escaped.
  • Numbering starts at one.

Questions

Add Prefix and Suffix FAQ

Can I change blank lines too?

Yes, but only after enabling Apply to empty lines.

Does the SQL preset execute anything?

No. It only formats text locally; it never connects to a database.