Delimiter

Updated: 10/02/2017 by Computer Hope

Pipe and double pipeA delimiter is one or more characters that separates text strings. Common delimiters are commas (,), semicolon (;), quotes ( ", ' ), braces ({}), pipes (|), or slashes ( / \ ). When a program stores lots of data it may use a delimiter to separate each of the data values. For example, "john|doe" has a pipe as its delimiter, a program or script could distinguish between the first and last name in a string of text.

Tip: If you are writing a script or program that has delimited text, we recommend using an uncommon delimiter. Using a comma as a delimiter has a good chance of getting split in the wrong place. If you need to use a comma as a delimiter use two or three commas instead of just one, unless the text is a name or something that does not have a comma.

Example of using a delimiter in the Perl programming language

use strict;
my $example = "John|Doe";
my ($first, $last) = split(/\|/, $example);
print "Hello $first,\nI see your last name is $last it is nice to meet you.\n"

In the example above, Perl code, the $example variable contains text with a pipe delimiter that is split into two new variables called $first and $last. Once the data has been split it prints the output results below.

Hello John,
I see your last name is Doe it is nice to meet you.

Windows command line for command delimiter

In the Windows command line for command, delimiters are specified using the delims= option. For example, delims=, indicates the delimiter is a comma.

CSV, Programming terms, Separator, Spreadsheet terms