Wildcard Characters

PANTHEON has some special characters available for an easier use of the program.
CHARACTER |
meaning and example |
% |
The % character is used in overviews and calculations where we want to select multiple values that share a common root. The % character replaces any character set or empty set.
Therefore, entering A% selects all records that start with A:
A1
A23
AB123
ABCDEF
Entering AB% selects all records that start with AB, for example
AB123
ABCDEF
Entering %3 selects all records ending in 3, for example
A23
AB123
Therefore, the % character works similarly to the * character, when using files in the MS-DOS operating system. |
_ |
The _ character is used in overviews and calculations. The _ character replaces any single character.
So, entering A_ will collect all records that are two characters long and start with A:
A1
A2
For example, entering A_1 will collect all records that are 3 characters long and start with A and end with 1, for example
AB1
A21
The _ character therefore works similarly to the the ? character, when using files in the MS-DOS operating system. |
[] |
Square brackets allow us to select or define an arbitrary set of characters to appear at a specific place in the record.
For example, the expression A[A-C]1 collects all records that are 3 characters long and start with A, end with 1, and have an A, B or C occurring in the second place:
AA1
AB1
AC1
Instead of a range of characters, we can also enter individual characters into the square brackets (see previous example). For example, this is how entry A[A,C]1 collects all records that are 3 characters long and start with A, end with 1, and have A or C appearing in the second place:
AA1
AC1 |