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.
Select your choices.
Click Process String.
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.