SQUOTE Function

Returns a single-quoted substring extracted from a string (cf. the Reality SQUOTE function).

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

Syntax

SQUOTE(string)

Syntax Elements

string A DataBasic expression that evaluates to a string.

Operation

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

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

Example

$OPTIONS D3

PRINT SQUOTE("ABC'DEF'GHI")

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