Z12’s String Plus similar to the Z12 String Converter but with more options and greater functionality.
Great for converting a list of items in to a bracketed, quoted, comma separated string ideal for a SQL IN statement.
Click HERE to go to the Z12 Web Tools site and start using the Z12 String Plus straight away.
Add your items to the Source List, 1 item per line.
Select your choices.
Click Process Items.
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.
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.