Find and replace in lists

In lists and tables possible to update in MONITOR G5 there is a function used to find and replace values. This is activated with the Find & replace button (Ctrl + H) on the function menu.

You enter the value you wish to search for and the value you wish to replace it with. It can for example be a quantity, a word, or if a checkbox should be marked. By default it is suggested to search for the value seen in the column on the row which is marked. The function finds and replaces in the column which is marked in the list/table.

Settings

You use the setting Replace all rows if you want to enter a value to replace with on all rows with the correct value in the column.

With the setting Only complete words you will only get hits for complete words when you search.

With the setting Lower-case/CAPITAL the search will take lower-case and capital letters into consideration.

Buttons

With the Replace button you replace the value in the field on the selected row.

With the Replace all button you execute all replacing items.

With the button Next you will move down the list to the next row containing the value you search for.

To be able to activate the Find & replace function you first have to make the list possible to update before you load it. This is done by using the button Updateable (Ctrl + U) in the toolbar of the procedure.