Z12's String Converter - The easiest way to convert a list of items into a string. Great for converting a list of items in to a bracketed, quoted, comma separated string ideal for a SQL IN statement or Microsoft Excel.
| Source List
|| Processed String
Paste / add your items to the Source List, 1 item per line.
Select your choices.
Click Process Items. Ta-Da!
('Item 1', 'Item 2', 'Item 3', 'Item 4')
Your items will be automatically processed each time an option is checked or unchecked.
Select ALL - Selects or deselects ALL options.
Sort - Sorts the items.
Trim - Trims spaces from the start and end of each item.
Distinct - Remove duplicate items.
Remove Blanks - Ignores blank lines in the Source List.
Bracket Spaced Items [ ] - Adds square brackets to items that contain one or more spaces.
Quotes - Wraps each item with the character(s) in the quote box. Maximum ten characters.
Delimit - Delimits the list with the character(s) from the delimit box. Maximum ten characters.
Prefix - Prefixes each item with the character(s) from the prefix box. Maximum ten characters.
Suffix - Suffixes each item with the character(s) from the suffix box. Maximum ten characters.
Concatenate - Concatenates the items into a single line / string.
Brackets - Encases the processed string with round brackets.
Process Items - Process your items based on the options you have selected.