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.

v-jingzhang's avatar
v-jingzhang
Community Support
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.