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.

AntrikshSharma's avatar
AntrikshSharma
Community Champion
3 years ago

jshedhai 

ReplacedValue = 
    Table.ReplaceValue ( 
    AddedCustom,
    each 
        if Text.Contains ( [Data], "#(lf)" ) 
        then [Data] 
        else false, 
    each "0",
    Replacer.ReplaceText, {"Data"} 
)