Replace carriage returns in a Power Query column?

Question

I can find no way to replace a carriage return in Power Query column. This SHOULD work:

Result=Table.ReplaceValue(QtrInc,"#(#)(cr)"," ",Replacer.ReplaceText,{"AcctName"})

But it has no effect.

Instead of "#(#)(cr)" I've tried:

"#(#)(000D)"
"#(cr)"
"#(#)(000D)"

But they have no effect. I tried to split the column on the character, but still no joy.

Is this a bug? Or have I blundered?

Answer 1

When #(cf) wouldn't work for me, #(lf) did work. ie Line Feed

Answer 2

"#(cr)" should work.

Are you absolutely certain you have carriage-return characters in the string?
When I try the replace here, it works flawlessly.

Answer 3

Just replace it with a space:

eg:

let  
    Source = Table.FromList(  
        {"abc" & Character.FromNumber(13) & "def"},  
        Splitter.SplitByNothing(),  
        {"Column1"}          
        ),  
  
    replaceCR = Table.ReplaceValue(Source,"#(cr)"," ",Replacer.ReplaceText,{"Column1"})  
in  
    replaceCR  

Source

Replace CR