Simultaneously Editing Records

The Global Replace dialog

The “Global Replace” dialog (in the “Edit” database menu) allows you to edit many or all records in your Papyrus Base database table simultaneously.

You could replace something as simple as the word “seller” with “sales person,” or it could also be something much more complex; this dialog also allows you to make use of all the calculation formulas available in Papyrus.

First, though, you need to select which field you want to apply the change to in the “In field” drop-down menu.

In the entry field below “Assign Field” you will enter the new value you would like to assign to all records with this field entry. You can make use of all Calculation Formulas in your entry.

“Global Replace” is often used for a String Addition:

name_affected_field = name_affected_field + new_string_value

If you only want to replace a part of the field with another word or expression, we recommend using the following syntax in the “replace” function:

REPLACE(name_affected_field,replacement_string, new_string_value)

Hint: when you want to enter actual text in “replacement_string” and “new_string_value” the text must be surrounded by quotation marks. Only field names and variables function like “placeholders” in the calculation formulas without quotation marks.

Fields can be deleted simply by assigning an empty string (“”).

In the top entry field “Condition (optional)” you can enter a condition under which the field manipulation should take place. Do not enter an “IF…” condition here; the field itself is already interpreted as a condition. Manipulations will only be carried out if the value exists at all (if you enter the name of the field here, Papyrus will check to see if it exists).

Under “Records” you can select which records with the selected data field should be manipulated–only selected records, only those in the current list, the complete table or only the current record.

The “Show Preview” option allows you to see how your table would look were you to make the change.

The “Replace” button will begin the replacement process. If your database is large (more than 10,000 records) this can take a few minutes, especially if there are relational links between records.

Once the replacement is complete, the “Global Replace” dialog will close.

Last updated by Leon Ramps on October 31, 2017