Brady LabelMark 3.1, User Manual

Page: 89 / 114

Importing Files
Select the Operator from the list:
= The field is the same as the value
<> The field is not the same as the value
> The field is numerically larger than the value
< The field is numerically smaller than the value
>= The field is numerically larger or the same as the value
<= The field is numerically smaller or the same as the value
IN The field appears in the list of values
LIKE The field is similar to the value
Type the Value for which the condition applies:
o
Unless the value is strictly numeric, enclose it in single quotes. For example, Value = 'A'.
o
The wildcard for one or more characters is % (not * as in past versions). For example,
Value = 'A-%' would return A-East, A-West, A-North, etc.
o
The single character wildcard is _ (not ? as in past versions). For example, Value = '_-
East' would return A-East, B-East, C-East, etc.
For more than one condition, use the “AND/OR” radio buttons: AND requires both
conditions to be met. OR requires one of the conditions to be met.
Select the Exclude duplicate rows/records to include only unique data.
Click Add to include the condition statement in the list. Click a condition statement in the list
and click Delete to remove it from the list.
Repeat these bullet points to add other conditions.
3. When you have entered all of your conditions, click Next and continue with step 8 of the
Importing Data into Label Files process.
Filter examples:
•
This example imports wires numbered between 1000 and 2000 from panel C:
Field Operator Value AND/OR
Panel = 'C' AND
Wire >= 1000 AND
Wire <= 2000 AND
•
This example imports all panels starting with the letter A (the % is the wildcard character):
Field Operator Value AND/OR
Panel LIKE 'A%' AND
Importing Files 83