Changing data with the CHANGE command

When you use the CHANGE command to change data, you must specify one or more column numbers to be included in the search (in the same way as you use the FIND command to find data).

For example, the following command changes all occurrences of the string CHAIR in all rows to the string TABLE in either of the columns with column numbers #5 and #6. 
CHANGE ALL CHAIR TABLE #5,#6
And the following command changes the next occurrence of the value 400 in column number 3 to 500: 
CHANGE 400 500 #3

To change the next occurrence of the string, press the RChange function key (F6). To find the next occurrence of the string and optionally change it, use a combination of the RFind function key (F5) and the RChange function key (F6).

To find the same string as you specified on the previous CHANGE primary command, specify an asterisk (*) as the search string.

To use the same replacement string as you specified on the previous CHANGE primary command, specify an asterisk (*) as the replacement string.

Further examples
CHANGE BLACK WHITE #4 #7
In TABL display format, changes the next occurrence of BLACK to “WHITE”, where BLACK is completely contained within either of the columns represented by column numbers 4 and 7.

In SNGL display format, changes the next occurrence of BLACK to WHITE, where BLACK is completely contained within either of the columns represented by column numbers 4 and 7, in the current row only.

CHANGE BLACK WHITE ALL #2 #8
In TABL display format, changes all occurrences of BLACK to WHITE, where BLACK is completely contained within either of the columns represented by column numbers 2 and 8, in all rows.

In SNGL display format, changes all occurrences of BLACK to WHITE, where BLACK is completely contained within either of the columns represented by column numbers 2 and 8, in the current row only.

Related concepts

Related tasks

Related references