= Replace UNICHAR(10) in Query Editor

[cristianml]

Hi,

I want to replace line breaks (UNICART(10) that my data has in a column in query editor.

How can I replace this?

My first thought was the the following but it doesn't work.

= Table.ReplaceValue(#"Replaced Value",UNICHAR(10),"-",Replacer.ReplaceText,{"COLUMN1"})

Any idea if is it possible to replace this?

Thanks

[AilleryO · Accepted solution]

Hi,

You can give a try as well to command clean on the Format button (Text.Clean in M).
It should work for both UNICHAR 10 and 13.

Let us know

[bcdobbs]

Try using Character.FromNumber(10) in your replace code rather than UNICHAR(10)