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.R...
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

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