I'm reading the data from excel where the field names having the space in-between and I would like to replace the space with "_"
Example: Dept No, Dept Name
I would like to see the Field Names as: Dept_No, Dept_Name
I've more than 80 fields, instead of manual rename from Select Tool is there any better option and will you please suggest.
Thanks in advance.
Solved! Go to Solution.
Hello @viswamtulasi!
I would suggest using the Dynamic Rename tool (in the Developer category). Connect your data input to the L connector and nothing to the R.
Select Formula as the Rename Mode and select your fields. Then, use this expression:
regex_replace([_CurrentField_]," ","_")
Hope this helps!
Attaching a sample workflow for your case. You can also achieve your results using Dynamic Rename tool with following configuration options.
Rename Mode: Formula
Select the fields you want to rename
Expression: Replace([_CurrentField_], " ", "_")