Forum Discussion
How to Replace Number Values with Text
I have about a dozen columns with lots of rows all with various numbers in them as well as other non-numerical data. I would like to use Power Query to replace all of those number values with "$$$" and keep all of the other text values. Is there an easy way to do this?
When I try to use the Replace Values functionality it only lets be pick specific numbers, but I need any number to be changed.
Thanks for any help!
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
3 Replies
NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))
Thanks for the help! I'm still learning, do you think you could add a bit of an explainer?
Hi Bibendum ,
Add a new step in the applied steps.
Enter the formula wdx223_Daniel provided, modify it.
Then press enter to confirm.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
