ADF Dataflow - Replace spaces with underscore in column names

Question

To remove spaces with underscore I am using replace($$,' ','_') expression in Select transformation

It works for a column "Period Key" and makes it "Period_Key" but for another column "Week in Month Description" it makes it "Week_in Month Description". So it is replacing only first occurrence

Can someone try this? Or how can we write regex for this?

Answer 1

I used below function and it worked

regexReplace($$,' ','_')