Splitting delimited values into a list
Address lists from an email, values inside a config file and single-line exports from a spreadsheet usually arrive separated by commas. Checking them one by one, or pasting them back into a column, is far easier when each value sits on its own line. Paste the text and the split list appears immediately, ready to copy.
Choose the delimiter: comma, semicolon, pipe or tab. With quote recognition on, a part wrapped in double quotes is read as a single item, so commas and line breaks inside it stay part of the value, and a doubled quote inside the item is restored to one character. Line breaks outside quotes end an item just as the delimiter does. Checkboxes control trimming and skipping empty items, and the result says how many were dropped.
One limit is worth knowing. If an unquoted item contains the delimiter, nothing in the text distinguishes one item from two, so it will split at that point. Quote the items when you build the delimited line in the first place, and converting back here restores the original values exactly.
Frequently asked questions
Wrap that item in double quotes. With quote recognition on, the wrapped part is read as one item and the commas inside stay part of the value. Without quotes there is no way to tell the two cases apart.
Yes. A line break outside quotes ends an item just like the delimiter does, so values copied across several lines are handled in one go.
Turn quote recognition off and double quotes are kept as ordinary characters. The result panel says so when that happens.