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
Solved! Go to Solution.
Hi @olehr
ReplaceChar function only replaces one char at a time.
Try Replace function
Replace([_currentfield],"Avg_","Constant")
Cheers,
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 ?
Replace(Replace([_currentfield],"Avg_","Constant"), "_", " ")
This should remove all underscores, replacing them with whitespaces, after you replace "Avg_" by "Constant"
Cheers,