Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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," "," ") ,
RemCR = Text.Replace(RemSpace,"<br />","#(cr,lf)"),
The first one works well but the second doesn't work at all. Any idea's?
Solved! Go to Solution.
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!
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |