User guide

Importing Files
Importing Files 67
 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
• This example imports panels from A-East and A-West:
Field Operator Value AND/OR
Panel = 'A-East' OR
Panel = 'A-West' OR
• The IN operator offers a concise way to handle a long list of values:
Field Operator Value AND/OR
Panel IN ('A-East', 'A-West') AND
The list is enclosed in parentheses and each member of the list is in single quotes.