LIST FORMATTING GUIDE · 6 MIN READ

How to join lines with commas, pipes or custom separators

Joining lines is simple until an item already contains the chosen separator. The right workflow depends on whether the result is for display, a query value, source code or a structured CSV file.

Choose the destination first

A comma works for a human-readable phrase, a pipe can separate command options and a space can build a sentence. Use the exact delimiter required by the destination rather than selecting one only because it looks compact.

Clean before joining

Remove accidental blank rows and trim obvious padding first. If duplicate items are not meaningful, deduplicate while the values are still one per line, where the result is easier to review.

Know when the task is really CSV

A plain join does not quote commas, line breaks or quotation marks inside a value. When values can contain those characters, use a CSV-aware converter and validate the imported result.

Worked example

Lines apple, banana and pear joined with ' | ' become 'apple | banana | pear'. An item such as 'Smith, Ada' needs CSV quoting if comma is the field separator.

Limitations to review

• Empty lines are intentionally omitted by the focused tool.
• Items are trimmed before joining.
• A joined string does not retain field types.