P5 Help

 

 

Find and Replace

 

Find and Replace is a dockable panel that can be used to search for values within a specified field and optionally replace them. It can also be used to find blank fields and to insert a value into them. It can be accessed by clicking the binoculars icon on the Record Management tool bar or by hitting CTRL-F on the keyboard.

 

 

Field to Search

Select the field in which to search for values. If a field in the active Session is selected when Find and Replace is opened, it will also be selected here.

Find What

Select or enter the value to search for, or leave blank to search for blank values. If a cell in the active Session is selected when Find and Replace is opened, the value in that cell will also be selected here.

Replace With

Select or enter the value that should replace the searched for value when the Replace All button is clicked. If this field is left blank, the searched for value will be cleared when the Replace All button is clicked.

Find Options

These options are only available for text fields and the Conditional Comments field. By default, Find and Replace will search for partial values in these fields. If the entire value should be matched, check the Match whole field box. If the case matters for the value to be replaced, check the Match case box.

Find All

Use this button to find all records in the active Session where the Field to Search and the Find What value match. A message box will display the number of matching records found. All matching records will be highlighted and the grid will be scrolled down to the first matching record.

Find Next

Use this button to find the next matching record. The matching cell will be highlighted and the grid will be scrolled down to the first matching record.

Replace

Use this button to replace the currently highlighted matching Find value with the Replace value.

Replace All

Use this button to replace all matching Find values with the Replace value. When the operation has completed a message box will display th number of records that were edited.