Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

M Query replace rich text

Hi everyone,   I am new to M so any help kindly appreciated.   I am trying to replace a rich text <br/M with a carriage return. I tried this:   RemSpace = Text.Replace(Source,"&nbsp"," ") , Re...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Actually, I got it wrong but thanks anyway..

     

    This worked...

     

    ReplaceHTMLBR= Text.Replace(RemSpace,"<br />","#(lf)#(cr)")

     

    I did not notice a difference between lf and cr or cr and lf. I'm remembering the type writer!

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

What about clicking the option Repalce values like below?

If you still need help, please share your data sample which could reproduce your scenario and your desired output so that we could help further on it.

Best Regards,

Cherry

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Actually, I got it wrong but thanks anyway..

     

    This worked...

     

    ReplaceHTMLBR= Text.Replace(RemSpace,"<br />","#(lf)#(cr)")

     

    I did not notice a difference between lf and cr or cr and lf. I'm remembering the type writer!