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. |