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.

[TimN]

Hi,

Similar approach but with REGEX_REPLACE:

REGEX_Replace([_CurrentField_], "\_+", " ")

[KrishnaChithrathil]

@Sshasnk 

you can do it with a select tool as well

[binuacs]

@Sshasnk One way of doing this

[Andrea_Shannon]

This is great, thanks!

[flying008]

@Sshasnk 

FYI.

REGEX_Replace([_CurrentField_], '[^[:alnum:]]+', ' ')