Find and Replace in Column Names
See Also

This dialog allows multiple columns to be renamed through a search and replace operation. For example, a find string of "X" and a replace string of "X[" on the column names X1,X2...X10 will create a pointer X[1...10]. Multiple occurrences within a single column name can be changed at once, so that a replacement of "10" with "1" in the column name "X1010" will give the new name "X11".

If the option Match case is selected, then only an exact match of case will be found, otherwise the case of the text will be ignored so that "XX" would also match "xX" "Xx" and "xx".

If the option Wrap at End of List is selected, then if you had used the Replace All button part way down the name list, the search will return to the top of the column name list when it reaches the end of the list, and then work down until it returns to the current position, and so do the replacement on the whole list, in spite of where the operation was started. If this is not selected, then the replacement will stop at the bottom of the name list.

Find What

String which specifies the text with the column names to search for, and then to be replaced.

Replace With

The string which specifies the new text that will replace the find string when the Replace or Replace All buttons are used.

Find Next

Find the next occurrence of the Find What string in the column names after the current search position (shown by the >> symbols in the current name displayed at the bottom of the dialog).

Replace

Replace the current or next occurrence of the Find What string in the column names with the Replace With string.

Replace All

Replace the current and all subsequent occurrences of the Find What string in the column names with the Replace With string.

Cancel

Close the dialog without making any more changes.

See Also

Rename Columns
Rename Column Cursor