Wildcard Characters

To find text values that share some characters but not others, use a wildcard character. A wildcard character represents one or more unspecified characters.

Use

To find

Examples

? (question mark)

Any single character in the same position as the question mark

"?ST" finds "GST" and "PST"

"5??" finds any account that begins with 5 and is followed by any 2 other digits (i.e. between 500 and 599)

* (asterisk)

Any number of characters in the same position as the asterisk

"accum* amort*" finds all your accumulated amortization accounts

"5*" finds any account that begins with 5 no matter how many digits follow the five (5, 50 – 59, 500-599, 5000-5999 etc.)

Where Wildcards can be used in CaseView:

In the Edit/ Find or Edit/ Replace:

When looking for a string of text, a group of accounts or a calculation, you can use the wildcards to broaden your search. This is especially useful if you are unsure of the spelling of a word or of the exact account number.

In functions:

You can use Wildcards in functions in CaseView to expand the flexibility of the function. The following example uses a wildcard characters in the form of a question mark (?) to link multiple leadsheets with similar numbers.

LS("D","BA","10.??")

Returns year to date leadsheet balances with normal adjustments using the number format of 10.??. The wildcard locates both numbers and letters. This function links balances from leadsheets 10.01, 10.02, 10.03 and so on.

Full listing of functions .

Wildcard Characters

Cookie Notice