List joiner

Paste a list, one value per line or a column copied from Excel, and get it back as one line: A1|A2|A3 for a Business Central filter, ('A1','A2') for SQL, CSV and more. Or split a joined line back into a list. Nothing leaves your browser.

FORMAT

SEPARATOR

QUOTE EACH VALUE

START WITH

END WITH

VALUES PER LINE

INPUT VALUES ARE SEPARATED BY

SORT

CASE

Trim spaces Remove blanks Remove duplicates

LIST

JOINED

In the Business Central format, a value that contains a filter character (& | ( ) < > = * ? @ or an apostrophe), contains .., starts or ends with a space, or is blank is put in single quotes, with any apostrophe written twice, so the filter reads it as plain text. Code fields are stored in uppercase, so pick UPPERCASE when the list is for a Code field such as No. Try the result in the filter expression tester. In the separator box, \n means a new line and \t a tab.