DQUOTE Function

Returns the first substring found that is surrounded by double quotation marks (cf. the Reality DQUOTE function).

This version of the DQUOTE function is provided for compatibility with D3. It is only available in D3, AP, PICK and R83 modes (set with the $OPTIONS statement).

Syntax

DQUOTE(string)

Syntax Elements

string A DataBasic expression that evaluates to a string.

Operation

The DQUOTE function returns the first substring found that is surrounded by double quotation marks. If no substring is found that matches this criterion, a null string is returned.

Note

This version of DQUOTE changes the values returned by the COL1 and COL2 functions (in the same way as the FIELD function).

Example

$OPTIONS D3
PRINT DQUOTE('ABC"DEF"GHI')

Prints DEF; that is, the part of the string that is enclosed in double quotes.