Z12 Web Tools
Z12's String Plus - The easiest way to convert a list of items.

Great for converting a list of items in to a bracketed, quoted, comma separated string ideal for a SQL IN statement.
       
Select ALL Sort Trim Distinct
Remove Blanks Bracket Spaced Items [ ]    
Quotes Delimit Prefix Suffix
Concatinate Brackets    
     
Source List Processed String
Add your items to the Source List, 1 item per line.
E.G.
Item 1
Item 2
Item 3
Item 4
Select your choices.
Click Process Items.
Simples...
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 2020 - All rights reserved.