Dynamic Renaming

[olehr]

Hi there, 

In my dataset, I have a bunch of fields that begin with "Avg_"  However, I want to rename them with "constant ". 

I have tried the formula: ReplaceChar(regex_replace[_currentfield],"Avg_","Constant")  However, I get Malfunctioned Function Call.  I would appreciate allt he help I can get :)

Kind regards

[Thableaus]

Hi @olehr 

ReplaceChar function only replaces one char at a time.

Try Replace function

Replace([_currentfield],"Avg_","Constant") 

Cheers,

[olehr]

Hi Thableaus, 

Thanks, that did the trick :)  

However, I forgot to mention that some of the fields fore some reason have this structure

Avg_Administrative Area_94,   while others have 

Avg_Service_Area_95

How could I at the same time remove the second or third underscore as well ?

[Thableaus · Accepted solution]

@olehr 

Replace(Replace([_currentfield],"Avg_","Constant"), "_", " ")

This should remove all underscores, replacing them with whitespaces, after you replace "Avg_" by "Constant"

Cheers, 

[olehr]

@Thableaus 

Thank you so much.