Find Tab
Allows you to search for specific strings in the active table.
The options and commands that are available on the Find tab are also available on all the Modify tabs.
Find what
Enter the string for which to search. This string can include text, numbers and any number of valid wildcards (for example, c*). The following wildcard characters can be applied to searches for fine tuning:
-
? finds any single character
-
* finds any string of characters
Look in
Defines the scope of the search. The contents of the Look in list are defined by the properties (column headings) in the active table.
Match case
Specifies that only the indicated combination of upper and lowercase letters are to be found.
Find Next
Initiates a search for the item that is part of the specified search scope. Each time you click Find Next, the software searches for and highlights the next item in the table that matches the defined search criteria.
Cancel
Closes the dialog box.
Modify Tab
Sets options for searching for and replacing data. The Modify tab consists of three tabs, each one dealing with a different replace methods: Replace (uses standard replace), LookUp (uses Lookup tables), and Factor (multiplies a number by a specified number).
Replace Tab
Replace with
Type the new replacement string or substring or select a replacement string or substring from a list of recently used replacement strings.
Replace what
Select what to replace. You can replace the entire string or, if you are using wildcards, replace only a piece of the string by specifying which wildcard or literal to replace. You can replace the 1st through 10th wildcards that occur within the Find what string, or you can replace the 1st through 10th literals that occur within the Find what string. Consider the following example:
-
Find what = A*D1??4
-
Replace with = X
-
Look in = Item Code
When the software finds item code ABCD1234, what you select in the Replace what determines the updated item code as follows:
-
First Wildcard (* or ?) = AXD1234
-
Second Wildcard (* or ?) = ABCD1X34
-
Second Literal = ABCX234
Replace
Replaces the item selected when you clicked Find Next. Each time you click Replace, the located item is replaced according to the parameters of the search criteria.
Replace All
Replaces all items that match the Find what criteria with the item defined in the Replace with.
LookUp Tab
The Lookup tab provides an advanced version of the replace functionality. Instead of typing on a user-defined replacement item, you use a lookup table. Lookup tables are XML files that are stored on the local computer. They provide a one-to-one cross-reference between strings. The cross-reference is case-sensitive.
Lookup table
Select the Lookup table to use. The list displays the names of Lookup tables you have recently used.
Default
Type an alternative replacement string or substring. If the software is unable to locate the replacement item in the specified lookup table, the Default is used instead.
Lookup what
Select what to replace. You can replace the entire string or, if you are using wildcards, replace only a piece of the string by specifying which wildcard or literal to replace. You can replace the 1st through 10th wildcards that occur within the Find what string, or you can replace the 1st through 10th literals that occur within the Find what string. As an example, consider the following Lookup table:
-
Find what = AB*1234
-
Lookup what = First Wildcard
-
Look in = ItemCode
-
When the software finds item code ABCD1234, it changes it to ABxy1234.
Lookup Tables
Opens the LookUp Tables dialog box where you can create, edit, and delete Lookup tables. Lookup tables are used interchangeably with the Modifier Builder. For more information, see Create a Lookup table.
Lookup
Replaces the item selected when you clicked Find Next. Each time you click Lookup, the located item is modified according to the parameters of the search criteria.
Lookup all
Replaces all items that match the Find what criteria with the item defined in the Lookup table list.
Factor Tab
The Factor tab also provides an advanced version of the replace functionality.
Unlike Find what on the Find, Replace, and Lookup tabs, you can only search for a numeric string or and substring on the Factor tab.
Factor by
Type a numeric value.
Factor what
Select the value to factor. You can factor the entire string or, if you are using wildcards, factor only a piece of the string by specifying which wildcard or literal to factor. You can factor any of the 1st through 10th wildcards that occur within the Find what numeric string, or you can factor any of the 1st through 10th numbers that occur within the Find what string. Consider following example:
-
Find what = ABCD1?34
-
Factor by = 8
-
Factor what = First Wildcard (* or ?)
-
Look in = ItemCode
-
When the software finds item code ABCD1234, it changes it to ABCD11634.
Factor
Factors the value selected when you clicked Find Next. Each time you click Factor, the located item is multiplied by the value defined in the Factor by box.
Factor All
Factors all items that match the Find what criteria with the value defined in the Factor by box.