Rename Cols

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Rename Cols


Rename column headers.



Rename columns 'first' to 'First' and 'Last' to 'last':


hwo to rename columns transform example






Change the column headers using the New name column.

Click Lower to change all the names to lower case.

Click Upper to change all the names to upper case.

Click Title to change all the names to title case.

Click Replace to replace name text using text, exact text or Regular expression matching.

Click Prefix/Suffix to add text to the front or back of all the names.

Click Unique to add '-2', '-3' etc to duplicate names, to make them unique.

Click Reset to change all the names back to their original name.



The names of column headers do not have to be unique.

Warnings are shown in the Info tab for duplicate column names (case sensitive).