Find Replace Tool

The Find Replace tool searches for data in one text field from an input table and replaces it with specified text field data from a reference table.

Configuration Properties

The Find Replace tool has two inputs:

Find Section

  1. Choose the radio button that best describes the part of the field containing the value to find:
  2. Select the Find Within Field - this is the field in the table with data to be replaced by data in the reference (R input) table.
  3. Select the Find Value - this is the field from the reference table containing the same values as the Find within Field field in the original (F input) table.
  4. Select optional search conditions:

Replace Section

You can choose to replace or append data in the table using the following radio buttons: