SQL Command in Business Rule removes line breaks (CR-LF)

0

Hi Martin,

is this a normal text field or rich text?
The value looks like a normal one. In this case you have two options.
a) Add some css so that the line breaks are preserved inside the HTML mail. In most cases they are ignored.
b) Replace the Character 10 and 13 with the HTML line break <br/>

REPLACE (MyField, CHAR (13) + CHAR (10), '<br/>')

I haven't shamelessly copied the above and haven't tested it myself.

Best regards,
Daniel

Hi Daniel! Thank you for the ideas. I’d prefer the css approach but I’m afraid the line breaks are removed from the text when the business rule is executed. I’m currently at the beach 😝 so will check later when back at the PC.

I'm currently sitting in the train travelling to Münster and the internet connection is like a sidescrolling game where you jump to evade obstacles. It's quite fast and every time you hit one, the internet connection is down. :)


It's interesting that the business rule removes the html tags. I now that a special function has been added to achieve exactly this. So I would have assumed that an SQL Command would return the value as is.

Regarding the css this is the property:
https://www.w3schools.com/cssref/pr_text_white-space.asp

Best regards,
Daniel

So you’re playing games on the train? Do you use Chrome where the dinosaur appears when you don’t have internet connection? 😂

The business rule doesn’t remove HTML tags. It’s just the cr-lf that is either removed or just hidden because of the css. Will check soon and report back.

Thank you, Daniel! I owe you a beer. It never occured to me that it might be just a css issue. Setting the property white-space to the value pre-wrap solved it. Again, thank you so much!

Solution:
p {white-space: pre-wrap;}