Z12 Web Tools

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.

Select ALL Sort Trim Distinct
Remove Blanks Concatinate Brackets  
Quotes Delimit    
Bracket Spaced Items [ ] Prefix Suffix  
Source List Processed String
Paste / add your items to the Source List, 1 item per line.
 Item 1
 Item 2
 Item 3
 Item 4
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.

Copyright © Z12 2021 - All rights reserved.