How do you add a New Line (Line feed) to a text string or a concatenated text string in a Formula
Prior to a recent NetSuite release, adding ‘<br>’ or ‘<br/> ‘ used to work for adding a new lines (line feed) in formulas used in saved search text formulas, in saved search custom column labels and in a default value formula for a customer field. This does not work anymore. I can strip out or replace line feeds by using a formula such as (REGEXP_REPLACE({description}, ‘[[:cntrl:]]{2}’, ”) but I cannot add line feeds by inserting ‘[:cntrl:][:cntrl:]’ into a concat function. Any insight appreciated!
Have you tried using CHR(13) for a carriage return and CHR(10) for a newline?
Although chr(10) and/or chr(13) work great in applications like Crystal Reports, I’ve never been able to make them work in NetSuite. In the case that something had recently changed I just tried them both again to no avail. I’ve seen other comments online suggesting to use /r , /rn, <p> etc. none have worked for me in NetSuite.
