Dynamic rename

[LuckyRaju]

I want to rename the field names dynamically like below

if filed name contains "Date"  , rename it to "Reg Date"

if filed name contains "Employee Name"  , rename it to "Employee Name"

if filed name contains "Employee ID"  , rename it to "Employee ID"

Original Field Names	Filed Names to be Renamed
Addl Reg Date	Reg Date
Addl Employee Name	Employee Name
Reg Employee ID	Employee ID

[caltang]

[A] = Original Field Names

IF CONTAINS([A], “Date”)

THEN “Reg Date”

ELSEIF CONTAINS([A], “Employee Name”) 

THEN “Employee Name”

ELSE “Employee ID”

ENDIF

Extend the condition as you see if. The Dynamic Rename tool can be used with the Formula option selected, and the Field Name double clicked.

[ShankerV]

Hi @LuckyRaju 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @LuckyRaju 

Step 1: Input

Step 2: 

IF contains([_CurrentField_],"Date")
THEN "Reg Date"
ELSEIF contains([_CurrentField_],"Employee Name")
THEN "Employee Name"
ELSEIF contains([_CurrentField_],"Employee ID")
THEN "Employee ID"
ELSE [_CurrentField_]
ENDIF

Many thanks

Shanker V

[binuacs]

@LuckyRaju If your column names are following the same pattern you can use the below regex function

[flying008]

Hi, @LuckyRaju 

Maybe you can use Dynamic-Rename tool with formula:

Trim(Right([_CurrentField_], Length([_CurrentField_]) - FindString([_CurrentField_], '')))