DELIMIT
- Last UpdatedJan 07, 2026
- 1 minute read
Description
Allows you to specify the delimiting character which separates the individual data fields when querying a specified data server. The default delimiter is the ~ (tilde) character.
Example
EXTERNAL DELIMIT $!!TOK_VAR ’&’
Syntax
>-- EXTERnal DELImit server_token text_char -->
Where:
-
server_token = An integer identifying the required data server channel and text is a single character only.
Note: The user must choose a delimiting character which does not occur within any data, otherwise Query will split the incoming data string in the wrong place.