We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Discussions

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

Dynamic Header rename between 2 characters

huyly0325
7 - Meteor

Hi everyone,

 

I am using dynamic header rename to remove a string between 2 characters "/.../". Could you please help me to correct my replace formula?

 

huyly0325_0-1578597450093.png

 

Thanks,

Huy

3 REPLIES 3
NickSm
Alteryx
Alteryx

Hey @huyly0325 

 

It looks like you may want to use the REGEX_Replace formula instead of the standard Replace which looks for specific strings.

huyly0325
7 - Meteor

Does the REGEX_Replace replace the header or just the data?

NickSm
Alteryx
Alteryx

In the Dynamic Rename tool you're still operating on the headers of the field, not the data within.  So all you should have to do is add the "REGEX_" to the formula you already have in there.

 

rename1.PNG

Labels