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.

3 Replies

  • 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"})

     

  • 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"} 
)
  • 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.