Forum Discussion

jshedhai's avatar
jshedhai
Regular Visitor
3 years ago
Solved

how to replace double zeros

Hi - is there a way to replace these double zeros with just one zero? I have been struggling figuring this out. I copied the value and it looks like this;  "0 0"     Thanks
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi jshedhai 

     

    You may try this

    = Table.ReplaceValue(#"Changed Type","0#(lf)0","0",Replacer.ReplaceText,{"Data"})

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

jshedhai Right-click the column header and choose Replace Values?

 

= Table.ReplaceValue(#"Changed Type","0
0","0",Replacer.ReplaceText,{"Data"})