<< Click to Display Table of Contents >> Navigation: Reference > Transforms > Rename Cols |
Rename column headers.
Rename columns 'first' to 'First' and 'Last' to 'last':
One.
•Change the column headers using the New name column.
•Click the button to change all the names to lower case.
•Click the button to change all the names to upper case.
•Click the button to change all the names to title case.
•Click the button to to replace name text using text, exact text or Regular expression matching.
•Click the button to add text to the front or back of all the names.
•Click the button to add '-2', '-3' etc to duplicate names, to make them unique.
•Click the button to change all the names back to their original name.
•Click the button to copy names to the clipboard.
•Click the button to paste from from the clipboard.
•The names of column headers do not have to be unique.
•Warnings are shown in the Info tab for duplicate column names (case sensitive).
•If you are pasting names, the format expected is comma delimited text. E.g.: name1,name2,name3.