SEARCH AND REPLACE

The Search and Replace form allows the user to search within the specified column and replace specific values with a new value or to replace all values in the column with a new value.

The Replace Item is automatically populated with the name of the column the user was on before launching the Search and Replace. The Current Value field is automatically populated with the value of the column the user was on prior to launching the search and replace.

Enter the item's new value. Press the Replace All button or the Replace button to begin the search and replace operations. Press the Cancel button to cancel the operation and return to the main form.

Replace Item

Enter the name of the column to be changed. The Replace Item is automatically populated with the name of the column where the cursor was located prior to calling the search and replace function.

Current Value

Enter the value to be changed. The Current Value is automatically populated with the value of the column where the cursor was located prior to calling the search and replace function.

New Value

Enter the value that will replace the existing value. The New Value will replace any current value in the column or all values in the column, depending on the button pressed.

SR_BUTTONS

Use the Replace All, Replace, or Cancel buttons to begin the search and replace process or to cancel the operation.

The Replace All button will replace all values in the existing column with the new value.

The Replace button will replace all values that match the current value (on the search and replace form) with the new value.

The Cancel button will cancel the search and return to the main form.

Replace All

Press the button to replace all values in the indicated column with the new value.

Replace

Press the button to replace matching current values in the indicated column with the new value.

Cancel

Press the button to cancel the replace operation and return to the main form.