SET DELIMITER

SET DELIMITER

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

SET DELIMITER

Specifies the current field delimiter.

Syntax

SET DELIMITER character

Parameters

characterAny valid character. The space, forward slash, comma, and quotation mark are the most commonly used.
If character is not a letter or a digit, it must be enclosed in quotation marks.
If character is a special character such as space or backslash, it must be enclosed in quotation marks.
If character is a string longer than one character in length, only the first character in the string is used as the delimiter.

Comments

The default field DELIMITER is the space character.

The specified character is used as a delimiter by the INPUT command (input from the terminal), by the ADD and CHANGE commands (input from an unstructured application document), and by the LIST and OUTPUT commands (output to the terminal or an unstructured application document) in either normal or comma-delimited format.

If the space is specified as the delimiter, then tab is also acknowledged as a delimiter, and multiple spaces are considered to constitute a single delimiter.

In comma-delimited format, the space causes the comma to be used as the delimiter for both input and output.

Example

set delimiter “/”

set delimiter ‘”‘

set delimiter “‘”

In the preceding examples, the slash, double quotation mark, and single quotation mark, respectively, are specified as the delimiter. (Only one delimiter character can take effect at one time.)

See Also

SET INPUT FORMAT

SET OUTPUT FORMAT

SET SPECIALSCAN

SET TEXTDELIMITER

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Leave a Reply

Your email address will not be published. Required fields are marked *

en_CAEnglish