Using wildcards
Wildcards are special characters that can stand in for unknown characters when querying values from a list.
There are two wildcards used in the application:
| Character | Description | Example |
|---|---|---|
| * | Matches any number of characters. You can use the asterisk (*) anywhere in a character string. | 123* finds 1234, 1237, 123456 |
| ? | Matches a single letter in a specific location. | 123? finds 1234, 1237, but not 123456. This wildcard (filter) allows only 4-digit length. |
In Financial Consolidation, you could use these wildcards to:
-
Show all accounts that start with the same characters. Ex: 211* shows all accounts starting with 211 (211000, 211800, 211900 and 211950).
-
Show all Consolidation Periods of the same category. Ex. *ACT* would show all Consolidation Periods with the text ACT in them, regardless of the position.
-
Show all Consolidation Periods of the same sequence. Ex. *001 would show the first sequence of all Consolidation Periods.