Changing Field Contents

CHANGE and REPLACE alter the contents of data fields.

Use CHANGE to substitute one character string for another, and REPLACE to substitute a new value for a field. CHANGE is issued to change alphanumeric strings within fields. REPLACE is used with either alphanumeric or numeric fields to replace the entire contents of the field(s).

Both operations can be applied to one or more instances from the current position to the end of the database. To change all instances in the database, use TLOCATE to find the first record before entering the CHANGE or REPLACE subcommand.

See CHANGE Command and REPLACE Command for additional information about CHANGE and REPLACE.


Information Builders