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!

Rookie Asked on February 15, 2021 in Saved Searches.
Add Comment
1 Answer(s)

Have you tried using CHR(13) for a carriage return and CHR(10) for a newline?

Beginner Answered on February 15, 2021.

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.

on February 15, 2021.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor