In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

remove special character from the headers

Sshasnk
8 - Asteroid

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

Input:

Last_nameAccount__NumPurchase____detailBuy_DetailLong_detailEquity____Detail
ABC1234567895625

 

Output:

Last nameAccount NumPurchase detailBuy DetailLong detailEquity Detail
ABC1234567895625
6 REPLIES 6
PanPP
Alteryx Alumni (Retired)

Hi @Sshasnk 

 

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

 

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

 

dynamicrename.png

 

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
13 - Pulsar

Hi,

Similar approach but with REGEX_REPLACE:

 

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

KrishnaChithrathil
11 - Bolide

@Sshasnk 

you can do it with a select tool as well

KrishnaChithrathil_0-1670390042658.png

KrishnaChithrathil_1-1670390067293.png

 

binuacs
21 - Polaris

@Sshasnk One way of doing this

binuacs_0-1670407613935.png

 

Andrea_Shannon
5 - Atom

This is great, thanks!

flying008
15 - Aurora

@Sshasnk 

 

FYI.

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

 

Labels
Top Solution Authors