Find and replace data

The Find Row and Replace Row is used to update numerous records at the same time using the Table Edit dialog box.

The information entered in the Find Row will be replaced with the data specified in the Replace Row. For example, if you enter 400 in the Hi Limit field in the Find Row and 500 in the Hi Limit field in the Replace Row, any records in the Data grid with a Hi Limit of 400 will have that value changed to 500.

Note: You can filter the data to show empty fields by entering null, "", or '' in the Filter Row.

To Find and Replace data

1. Enter the criteria you want to replace in the Find Row.

2. Enter the replacement values in the corresponding fields in the Replace Row.

   Each field entered in the Find Row must have an equivalent field in the Replace Row.

3. Press Enter.

   Any records in the Data grid meeting the criteria established in Step 1 are updated with the values configured in Step 2. The change icon appears on the affected fields and rows. See the figure below for an example.