Z12 String Converter

Z12’s String Converter – The easiest way to convert a list of values to a comma separated string.

Great for converting a list of items in to a bracketed, quoted, comma delimited string ideal for a SQL IN statement.

Click HERE to go to the Z12 Web Tools site and start using the Z12 String Converter straight away.

Add your items to the Source List, 1 item per line.
For example:
Item 1
Item 2
Item 3
Item 4
Select your choices.
Click Process String.
Simples…

Select ALL – Selects or deselects ALL options except Trim Words And Delimit.
Trim – Trims spaces from the start and end of each item.
Distinct – Remove duplicate items.
Delimit – Delimits the list with the character(s) in the delimit box. Maximum five characters.
Brackets – Encases the processed string in round brackets.
Quotes – Wraps each item with the character(s) in the quote box. Maximum five characters.
Remove Blanks – Ignores blank lines in the Source List.
Concatenate – Concatenates the items into a single line / string.
Sort – Sorts the items.

While you’re here why not take a look at the Z12 Word Trimmer.

%d bloggers like this: