remove special character from the headers

Sshasnk

I have a dataset where I have to remove the special character from headers

Input:

Last_name	Account__Num	Purchase____detail	Buy_Detail	Long_detail	Equity____Detail
ABC	123	456	789	56	25

Output:

Last name	Account Num	Purchase detail	Buy Detail	Long detail	Equity Detail
ABC	123	456	789	56	25

PanPP

Hi @Sshasnk 

1) You can use the dynamic rename tool as shown below.

Formula: replacechar([_CurrentField_], " _ ", " ")

2) You can also use a select tool to rename columns.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution so other community members can see it. If you have any other questions, please let us know.