AnsweredAssumed Answered

New line CDATA (Gel Script)

Question asked by Peerawat.k on Oct 22, 2015
Latest reply on Oct 29, 2015 by Peerawat.k

Hi All,

 

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

 

<textarea>

${v_cr_description}

</textarea>

 

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.

 

Thanks,

Peerawat K.

Outcomes