3305 Main Street Ste 019 Vancouver, WA 98663

TSGLPrefixMask

Description

This function returns a prefix mask that can be used with with any GL function that uses a Prefixes argument.

Syntax

= TSGLPrefixMask ( PrefixA , PrefixB , PrefixC , DataFolder )

Example

=TSGLPrefixMask('10','3%')
Returns a mask indicating prefix A should be 10 and prefix B should start with 3: "10-3%"

Arguments

Argument Description
PrefixA Optional - Specifies a value or mask for Prefix A. A mask may contain a combination of literal characters and wildcards. Use the percent symbol (%) to indicate any number of characters. Use an underscore character to indicate a single character placeholder. If not supplied or left blank, and Prefix A is used in the account format, a default value of "%" is used.
PrefixB Optional - Specifies a value or mask for Prefix B. A mask may contain a combination of literal characters and wildcards. Use the percent symbol (%) to indicate any number of characters. Use an underscore character to indicate a single character placeholder. If not supplied or left blank, and Prefix B is used in the account format, a default value of "%" is used.
PrefixC Optional - Specifies a value or mask for Prefix C. A mask may contain a combination of literal characters and wildcards. Use the percent symbol (%) to indicate any number of characters. Use an underscore character to indicate a single character placeholder. If not supplied or left blank, and Prefix C is used in the account format, a default value of "%" is used.
DataFolder Optional - If blank or not specified, the current data folder will be used. If specified, account format will be based on the data folder specified. The value used for this argument may be a text value, a cell reference, or a range containing one or more data folder paths. If a range is specified, the file format for the first data folder is used.