Find rows with specified data content in particular fields and replace those values with a new value. You can choose any type of field; however, the replacement value must have the same data type as the field you choose. The changes appear immediately in the Table window.

Dialog box options

 

Find What

Type the value you expect to find in that field of the target row. You can specify any printable character, including spaces. For example, you could search for rows where the LastName field equals Johnson.

For text and memo fields, you do not have to enter the precise value for which you are searching. You can enter the beginning of a phrase, such as Bank, to find all rows beginning with the word Bank.

To search for a value stored in another field, a memory variable, or an expression, use parentheses. dBASE Plus searches the field specified in Located in Field for the value that the expression returns.

Field names. dBASE Plus searches for rows where the selected field matches the value of another field in the same row. For example, you could search for rows where the YTD_Sales field equals the Ord_Rev field by selecting YTD_Sales in the Located in Field list, and specifying (Ord_Rev) in the Find What text box.

Memory variables. dBASE Plus searches for rows where the selected field matches the value in the memory variable. For example, you could search for rows where the YTD_Sales field equals the value of the TotSales memory variable by selecting YTD_Sales in the Located in Field list, and specifying (TotSales) in the Find What text box.

Expressions. dBASE Plus searches for rows where the selected field matches the value that the expression returns. For example, you could search for rows where the Sell_Price field equals nine times the quantity by selecting Sell_Price in the Located in Field list, and specifying (QTY*9) in the Find What text box.

Located In Field (left)

Select one of the rowset’s columns in which you expect to find the value you specify in the Find What box.

Replace With

Enter the new value or data content you want to place in the found row’s field that you specify in the right Located In Field box.

Memo fields. Replacement value must have a character data type.

Non-memo fields. Replacement value must have the same data type as the field.

Numeric fields. The length of the new value must not exceed the field width. Otherwise, the data in the field is replaced with an approximation to the new value in scientific notation, if it will fit. If scientific notation will not fit, the field is replaced with asterisks, which permanently removes stored data.

Expressions. Like the Find What text box, you can specify a value stored in another field, memory variable, or an expression by surrounding the expression with parenthesis.

Located In Field (right)

Select one of the rowset’s columns in which you want to place the new value you typed in the Replace With box.

Search Rules

Click a radio button to choose either:

Partial Length The search string will be found within larger strings.

Exact Length The search string must match exactly (such as a whole word).

Match Case The case of the search string must be matched.

Find Next

Find the next occurrence of the search value.

Replace

Replace the specified replacement field of the current row with the Replace With value.

Replace All

Replace all occurrences of the specified replacement field with the Replace With value.

How to get there: In Table Run mode, choose Table|Replace Rows.