QPR Installation Instructions

Wildcards

Wildcards

Previous topic Next topic  

Wildcards

Previous topic Next topic JavaScript is required for the print function  

Wildcards can be used in expressions (formulas) with scorecard, measure and series identifiers. There are two types of wildcards in QPR Metrics: one for representing any string of characters of any length and one for repenting any single character.

 

The two wildcard types cannot be mixed, because they both use the same wildcard character - question mark ("?"). The distinction between the types is contextual as follows:

 

Format

Description

Examples

?

Substitute for a string of characters of any length.

?

<string>?

Substitute for a string which starts with a constant string, <string>,and ends to any single character.

sc?

?<string>

Substitute for a string which starts with any single character and ends to a constant string, <string>.

?ea1

<string 1>?<string 2>

Substitute for a string which starts and ends with constant string, <string1 > and <string 2>, and it has any single character in the middle.

m?a9

??[?...?]

Substitute for any fixed length string.

??

???

?????

<string>??[?...?]

Substitute for a string which starts with a constant string, <string>, and ends to any fixed length string.

sc??

sc???

sc?????

??[?...?]<string>

Substitute for a string which starts with any fixed length string and ends to a constant string, <string>.

??1

???12

?????_measure

<string 1>??[?...?]<string 2>

Substitute for a string which starts and ends with constant string, <string1 > and <string 2>, and it has any fixed length string in the middle.

sc??1

me???_measure

 

Note: With the current wildcard implementation, it is not possible to match patterns which consist of variable length strings (represented with wildcard characters) and constant strings.

In terms of the standard wildcards, expressions "*hijk", "abc*", or "*hijk*" are not possible with QPR Metrics.