Joining a line list into delimited values
Values copied from a spreadsheet column or jotted down in a text file normally sit one per line. Putting them into a search filter, a SQL IN clause or a tag field calls for a single delimited line instead. Paste the list and the joined result appears at once, ready to copy.
Pick a delimiter: comma and space, plain comma, semicolon, pipe or tab. Checkboxes decide whether each line is trimmed and whether blank lines are skipped, and the result reports how many lines were dropped. Turning on quoting wraps every item in double quotes and doubles any quote inside an item, which is what makes the values survive a later conversion back into a list.
The case worth watching is an item that already contains the delimiter. Joined without quotes it looks fine, but converting the line back splits that item in two. The tool counts those items and says so, recommending that you turn quoting on. The number of items joined and the length of the result are shown as well, so you can confirm nothing went missing.
Frequently asked questions
Left unquoted, that item will split in two when the line is converted back into a list. The tool counts such items and tells you, so turn quoting on; quotes inside an item are then doubled.
They are skipped by default, and the result says how many were dropped. Turn the option off and an empty line becomes an empty item instead.
Use the tool that turns delimited values back into one item per line. If you wrapped items in quotes, enable quote recognition there so the original values are restored exactly.