I have custom gel script to select description (String) of project from oracle database and sent to user via email
In the email content I use CDATA and html tag "Text Area" as below
The problem is when user use "Enter" in the description. It's not show new line in the email content.
I try use REPLACE function as below when select description field.
1.REPLACE(a.GS_CR_DESCRIPTION,chr(10),'<br>') AS GS_CR_DESCRIPTION
2.REPLACE(a.GS_CR_DESCRIPTION,chr(10),'\n') AS GS_CR_DESCRIPTION
but It's not work.