Forum Discussion

Bibendum's avatar
Bibendum
New Member
4 years ago
Solved

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 "$$$" ...
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    4 years ago

    NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
4 years ago

NewStep=Table.ReplaceValue(PreviousStepName,"","",(x,y,z)=>Text.Combine(Text.SplitAny(Text.From(x),"0123456789"),"$"),Table.ColumnNames(PreviousStepName))

Bibendum's avatar
Bibendum
New Member
4 years ago

Thanks for the help! I'm still learning, do you think you could add a bit of an explainer? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.