Forum Discussion

cristianml's avatar
cristianml
Post Prodigy
4 years ago
Solved

= Replace UNICHAR(10) in Query Editor

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

Data Protection
General Comment
Interesting Links
Need Help
Tips and Tricks
  • AilleryO's avatar
    AilleryO
    4 years ago

    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

2 Replies

  • bcdobbs's avatar
    bcdobbs
    Community Champion
    4 years ago

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

     

  • AilleryO's avatar
    AilleryO
    Memorable Member
    4 years ago

    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