DELIMIT
- Last UpdatedJan 24, 2023
- 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 -->
Here, '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.