How to add line breaks to a FormulaText search result column

AI generated answer (using internal Slack threads):

To add line breaks to a FormulaText search result column in NetSuite, you can use the

chr(10)

or

'\n'

(newline character) in your formula. For example, if you have two fields

customfield1

and

customfield2

and you want to display them with a line break in between, you can use the following formula:

{customfield1} || chr(10) || {customfield2}

or

{customfield1} || '\n' || {customfield2}

Please note that the line break might not be visible in some exports like Excel or PDF. In such cases, you might need to manually adjust the cell formatting in the exported file. If you want to add line breaks in a HTML formula, you can use the

<br/>

tag. However, please note that HTML tags might not be supported in FormulaText fields. For example, if you want to concatenate item name and description with a line break in between, you can use the following formula:

NS_CONCAT({item.name}||' - '||{item.description}||'<br/>')

Remember to replace commas with line breaks if you are using the

NS_CONCAT

function, as it uses a comma as the native separator. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******