GETOPTIONS( ) function

Returns the current setting for the specified ACL option (Options dialog box setting).

Syntax

GETOPTIONS(option)

Parameters

option

Character constant. Specifies which ACL option to return a setting for.

The name of the option must be specified exactly as it appears in the list below, and it must be enclosed in quotation marks:

  • separators – returns the settings for the three ACL separator characters, in the following order: decimal place symbol, thousands separator, list separator

Note

Currently, “separators” is the only option that can be specified for the GETOPTIONS( ) function.

Output

Character.

Remarks

If a script needs to change one or more of the ACL separator characters, the GETOPTIONS( ) function provides a method for retrieving the initial settings. The initial settings can be stored in a variable and then reinstated at the end of the script. For example:

v_SeparatorsSetting = GETOPTIONS("separators")
SET SEPARATORS ",.;"
<script content>
SET SEPARATORS "%v_SeparatorsSetting%"

Examples

Example Return value

GETOPTIONS("separators")

.,,

Returns the three characters that are specified for the following options in the Options dialog box, in the following order:

  • Decimal Place Symbol

  • Thousands Separator

  • List Separator

Related reference
SET command


(C) 2015 ACL Services Ltd. All Rights Reserved.