|
Extract Using Wildcard Filters |
|
|
|
|
Sun Documentation -
Vision XL
|
|
You will now create a new Reference File Fill that extract Account Code and Account Name from the Chart of Accounts Table, where the letters ‘SALE’ (case-insensitive) appear in the Account Name data item. The finale definition form should look like this: Wildcard Filter You can use a number of search expressions, i.e. wildcards, in definition forms and dialog boxes to search for the information you entered and extract it to Excel. Wildcards are available when filtering on any data item and description.
The wildcard filters are:
- ‘%’ (percent) to substitute any number of characters for the percent
- ‘_’ (underscore) ) to substitute any single character for each underscore
- ‘[]’ (square brackets) to substitute any single character within the specified range, for example , [a-f], or the specified set, for example, [abcdef]
- ‘[^]’ (circumflex and square brackets) to substitute any single character not within the specified range, for example, for example , [^f], or the specified set, for example, [^cdef]
- ‘>>’ (greater than twice) to define the search as case insensitive. This can be used in conjunction with all other wildcards.
|
Save this report as CA – Workbook File in order to recall it later: The Excel output will look like this:
|
Sun Documentation 
