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 "$$$" 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!

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))

3 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity 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.