Z12 Web Tools
Z12's String Converter - The easiest way to convert a list of items to a comma separated values (csv) string.

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

Try our String Plus it can do even more.
Source List     Processed String
Select ALL
Trim
Distinct
Delimit
Brackets
Quotes
Remove Blanks
Conactinate
Sort
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 String.
Simples...

Select ALL - Selects or deselects ALL options.
Trim - Trims spaces from the start and end of each item.
Distinct - Remove duplicate items.
Delimit - Delimits the list with the charater(s) from 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.

Copyright © Z12 2021 - All rights reserved.