DELIMIT
- Last UpdatedFeb 15, 2024
- 1 minute read
Description:
Allows the user 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 is 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.