RE: 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!
an HTML formula and concatenation of ‘<br>’ works for me