Delimiter is a simple utility used to take a list of numbers and convert them to a comma delimited list. *
  • You can use strings instead of numbers and choose your own delimiter, a comma is the default delimiter.

Installed Version

A shortcut should be created on your desktop, but just in case Delimiter typically installs to:

'C:\Program Files\Data Juggler\Delimiter\' directory

Source Code

The source code version you may need to set Delimiter as the startup project if you receive any error messages about class libraries cannot be started directly.

I use Delimiter when I have a series of numbers returned from a SQL Query or from an Excel spreadsheet when I want to perform an 'In' query such as the following:

Select * From Network Where NetworkID In (33804, 98053, 28030, 107439)

Another useful function is the Get Distinct List & Copy' button that returns only one item of each number even if their are multiple occurrences of that number.

After you enter or paste in your items, click the 'Add Delimiter & Copy' button or the 'Get Distinct List & Copy' button.

The 'Clear' button clears the Items text box.

This program was very simple to write, but it saves adding a lot of commas to a list of numbers by hand.

Last edited Apr 4, 2014 at 3:11 AM by Corby, version 3