DataBasic Reference > MultiValue Compatibility > Statements and Intrinsic Functions > SQUOTE Statement

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

SQUOTE Function (DataBasic MultiValue Compatibility) (m6187ai+squote_f.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

SQUOTE Function

Returns the first substring found that is surrounded by single quotation marks (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 SQUOTEfunction 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.

RealityV15.0Comment on this topic