how to replace double zeros

[jshedhai]

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

[v-jingzhang · Accepted solution]

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]

@jshedhai 

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

[Greg_Deckler]

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

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