Wildcards

Wildcards can be used to select multiple wireframe names. A wildcard is a special character that can stand for either a single character or a string of text.

Wildcard	Description	Example
*	Matches any number of characters. You can use the asterisk anywhere in a character string.	wh* finds what, white, and why, but not awhile or watch.
?	Matches any single alphabetic character.	B?ll finds ball, bell, and bill
[ ]	Matches any single character within the brackets.	B[ae]ll finds ball and bell but not bill
!	Matches any character not in the brackets.	b[!ae]ll finds bill and bull but not ball or bell
-	Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A).	b[a-c]d finds bad, bbd, and bcd
#	Matches any single numeric character.	1#3 finds 103, 113, 123

Examples:

	Identifier
WF Name	LH*	*Zone_3*	*Zone_#*	*Zone_[AB]*	*Zone_[!AB]*	*Cut*
LH_Zone_4C_S4L	R	Q	R	Q	R	Q
LH_Zone_3_S4L	R	R	R	Q	R	Q
LH_Zone_3_S4U	R	R	R	Q	R	Q
LH_Zone_B_S1_Clip	R	Q	Q	R	Q	Q
PH_Zone_4C_S1_Cut	Q	Q	R	Q	R	R
PH_Zone_A_S1_Cut	Q	Q	Q	R	Q	R
PH_Zone_4E_S2_Cut	Q	Q	R	Q	R	R

The * and ? wildcards, described above, can be used anywhere in Micromine, even when querying SQL databases that accept % and _ (underscore) wildcard characters.

• The percent sign represents zero, one, or multiple numbers or characters.
• The underscore represents a single number or character.

These symbols can be used in combinations, for example:

Example	Finds
100%	Any values that start with 100
%100%	Any values that have 100 in any position
_00%	Any values that have 00 in the second and third positions
1_%_%	Any values that start with 1 and are at least 3 characters in length
_1%2	Any values that have a 1 in the second position and end with a 2
1___2	Any values in a five-digit number that start with 1 and end with 2

Note: The # wildcard will not work when setting a Drillhole Database filter, since ADO does not have an equivalent for the # wildcard.

Literals

\ is a special character which indicates that the character directly following it should be interpreted literally.

This is useful when special characters in a string (e.g. single or double quotes, or wildcards) need to be treated literally rather than as special characters.

To treat the backslash character literally, use two backslashes.

Example	Finds
1*\%	10%, 15%, 100%, etc.
\\D*	\Data, \Documents, etc.