You are here: Help Topics > Customization > Calculation > Wildcard Characters

Wildcard characters

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

Character	Description	Examples
?	Represents a 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)
*	Represents 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 (5, 50-59, 500-599, 5000-5999, etc.).

Character

Description

Examples

Represents a 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)

Represents 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 (5, 50-59, 500-599, 5000-5999, etc.).

You can use wildcard characters in CaseView functions to expand the flexibility of the function. For example, the function LS("D","BA","10.??") returns year to date leadsheet balances with normal adjustments using the number format of 10.?? (10.01, 10.02, 10.03 and so on).

Wildcard characters

Cookie Notice