How to join multiple lines into one
A column copied from a spreadsheet, a list kept in a notes file, IDs pulled out of a log - anything written one item per line often has to end up on a single line. Think of a keyword list for a search box, the values of a SQL IN clause, or one cell in a spreadsheet. Paste the text, choose a separator, and the joined line appears right away.
Pick a comma, a comma and a space, a space, a semicolon, a tab or a pipe, or type your own separator. In the custom field you can write a tab as backslash t and a newline as backslash n; to use a literal backslash, type it twice. Choosing no separator joins the items with nothing between them.
By default each line is trimmed and blank lines are dropped. The result states how many lines were skipped, so you can check the count against what you expected. Turn on quoting to wrap every item in double quotes, with inner quotes doubled the way CSV expects. To go the other way and split one line into many, use the delimiter converter.
Frequently asked questions
Yes. A column copied vertically arrives separated by line breaks, so paste it in and pick the comma separator. If the values themselves contain commas, turn on the quoting option as well.
The skip-blank-lines option is on by default, so lines containing only spaces are dropped. The result shows how many were skipped, and turning the option off keeps blank lines as items.