Replace (Database)




“Replace” replaces the value in the active field in all visible records with the current record's value, or the user entered value.

Enhancement Pack


This is one of the over 40 features bundled in the Enhancement Pack for AppleWorks.


Replaces the value of the selected field in all visible records with your choice of: the value from the current record; Fill Down only after the current record; replace blanks with the previous non-blank; increase or decrease; a series of numbers; replace one string with another; convert text to Title Caps; copy from other fields; trim spaces, delete surrounding quotes, break up another field by a delimiter; or calculate a formula for each.

Some of the options for replacing field values.

If you change a field value, you need to “enter” it in AppleWorks (by either hitting the Enter key or switching to another field then back again) before running “Replace”.

The actual action in this script consists of one simple command, which is effectively:

set value of field fieldName in (every record in database of front document whose visible is true) to fieldValue

Operates on the front document, which must be a database document.

This script works with AppleWorks 6, not version 5 or earlier.

Only registered users are permitted to use the supplied files after 14 days.

Please email us any queries about this page.