Replace newline with break in email using AMPScript

Question

I have a Data Extension with some text fields. In the text fields have copy text with newlines.

When I output this copy text when rendering the email I would like to replace the newlines from the Data Extension fields into with <br/>.

Is there any workaround with AMPScript?

Answer 1

You can use the replace() AMPscript function:

%%[

var @copyText, @copyTextAdj
set @copyText = AttributeValue("copyText")
set @copyTextAdj = replace(replace(@copyText ,char(13),""), char(10),"<br/>")

]%%
Original:%%=v(@copyText)=%%
<br>Adjusted: %%=v(@copyTextAdj)=%%

Reference:

Function Index

Answer 2

I solved that issue with SSJS:

var text = Variable.GetValue("@copytext");
var newtext = text.replace(/[\r\n]/g,"
");
//Set the Variable to be accessible in AMPscript
Variable.SetValue("@newcopytext",newtext);