Filtering Displayed Values in eCADSTAR
This topic describes how to filter the displayed values for appropriate fields in eCADSTAR tables. It describes the wild card values that can be used, and indicates where they can be used together when required. For a particular field in a dialog, the Online Help will indicate whether displayed values can be filtered using these methods.
Filtering Values Without Using Wild Cards
In an appropriate field, if you enter an alphanumeric value without any wild card characters, then items are displayed that contain the entered value in any position. The entered value is case-insensitive. This is illustrated below
| Value entered | Displayed items |
|---|---|
| i | FID1, FID2, FID3, IC1, IC2, IC3 |
You can filter the displayed items more precisely using the wild card characters described in this topic.
Using the "||" Characters as the OR function
Adding the "||" characters between values lists items that contain any of the values separated by them. These characters are referred to as pipes or vertical bars on the keyboard. Entered values are case-insensitive.
| Value entered | Displayed items |
|---|---|
| GND||VCC||FORCE | FORCE_AP,GND0V,VCC |
Using the "&&" Characters as the AND function
Adding the "&&" characters between values lists items that contain all of the values separated by them. A space is required between the "&&" characters and the specified values. These values are case-insensitive.
| Value entered | Displayed items |
|---|---|
| HOST && MOSI | HOST_SPI_MOSI |
Using the "*" (asterisk) Character
The "*" character can be used as follows when filtering items. It can also be used with square brackets. If it is added after a value, then all items are listed that contain the values before this character. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| C* | C1, C10, C100, C2, C20, C200 |
| C1* | C1, C10, C100 |
| C2* | C2, C20, C200 |
| C10* | C10, C100 |
| C20* | C20, C200 |
If the "*" character is added before a value, then all items are listed for which this value is the last character. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| *2 | C2, C12, FID2, R12 |
If the "*" character is added before and after a value, then all items are listed which contain the relevant character in any position. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| *2* | FID2, L2, R20, R21 |
Using the "?" Character
The "?" character allows you to only display items that have the same number of characters as the number of "?" characters that you specify. For example, if you specify "?", then items displayed that have only a single character. If you specify "??", then attribute values are displayed that have two characters. The "?"character can be used with square brackets.
| Value entered | Displayed items |
|---|---|
| ?? | C1, C2, C3, C4 |
| ??? | C10, C11, C12, C13 |
| ???? | FID1, FID2, FID3 FID4 |
Using "[ ]" (Square brackets)
Square brackets allow you to match the values contained within them. If you add multiple values, then items are listed that contain any of the specified values. You can also match a range of items by using the “-“ (hyphen) character. Exact matches can be displayed using square brackets with the "*" character.
Items within square brackets are case-insensitive.
Using Square Brackets to Display Exact Values
Exact values can be displayed by using the following string:
[x*]y, where "x" is the first search character and "y"
is the remainder of the search string. For example:
[2*] lists only values of "2".
[2*]2 lists only values of "22".
[D*]IODE lists only values with the exact description of DIODE.
*[D*]IODE* lists any value with the description that contains the word DIODE.
| Value entered | Displayed items |
|---|---|
| [2*] | 2 |
| [2*]2 | 22 |
| [D*]IODE | DIODE |
| *[D*]IODE* | DIODE_X Y_DIODE ZDIODE |
Using the “?” Character with Square Brackets
"??[ ]" lists items that comprise any two characters, followed by a character that is specified within square brackets. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| ??[3] | C13, C23, CN3, IC3, R13, TP3 |
[ ]?? lists items that comprise a character that is specified within square brackets, followed by any two characters. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| [r]?? | R10, R11, R12, R13, R14 |
?[ ]? lists items that comprise any character, followed by a character that is specified within square brackets, followed by any character. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| ?[1]? | C10, C11, C13, R10, R11, R12 R13, R14 |
| ?[2]? | C20, C21, C22, R20, R21 |
| ?[3]? | C30 |
| ?[12]? | C10, C11, C13, C20, C21, C22, R10, R11, R12, R20, R21 |
| ?[123]? | C10, C11, C13, C30, C20, C21, C22, R10, R11, R12, R20, R21 |
Matching a Range of Values
The “-“ (hyphen) character allows you to list items that contain values within a specified range. Items are listed that are within the range, or match the "From" or "To" value. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| C[1-4] | C1, C2, C3, C4 |
Using Multiple Square Brackets
Because each character inside the brackets is matched to a single value or range of values for an item, multiple pairs of square brackets are sometimes required. The following example specifies the first character as “F”, the second character as I or Y, and the third character as D or G. The fourth character can be any value.
| Value entered | Displayed items |
|---|---|
| F[IY][DG]? | FID1, FID2, FID3 |
Reversing Specified Conditions
The "^" (caret) character can be used within square brackets to reverse the specified filter conditions. For example, if this character is not used, then items are listed that contain the value "1" or "3" in the specified position, as shown below.
| Value entered | Displayed items |
|---|---|
| C[13]? | C10, C11, C30 |
If you add the "^" character within the square brackets, then items are listed that do not contain the values "1" or "3" in the specified position, as shown below.
| Value entered | Displayed items |
|---|---|
| C[^13]? | C22, CN1, CN3 |
The "^" character must be at the start of the content within square brackets.
Using the “*” Character with Square Brackets
The "*" character can be used with square brackets to include any other characters, as well as the values in the square brackets. For example, if you specify [CD]*, then any item is displayed which starts with “C” or “D”. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| [CD]* | C26, C27, C28, D1 |
if you specify the "*" character before the square brackets, then any item is displayed which ends with a value specified in the square brackets. This is illustrated below.
| Value entered | Displayed items |
|---|---|
| *[12] | C1, CN2, TP1, TP2 |
If you specify a value before the square brackets, then items are displayed which start with this value, followed by a value in the square brackets.
| Value entered | Displayed items |
|---|---|
| C[DN]* | CN1, CN2, CN3 |
