Trying to do a NetSuite formula for a saved search to add line break after each item however isn't working as expect? Output I'd like onto one line is: 10111 - Item A 10222 - Item B 10044 - Item C Currently its output is like: 10111 - Item A, 10222 - Item B, 10044 - Item C Formula Text I have is: NS_CONCAT(TO_CHAR({item.name} || '-' || {item.description})) Also tried this as a HTML formula but doesn't work: NS_CONCAT(TO_CHAR({item.name}||TO_CHAR('<br>')||{item.description}))

I think this should work as HTML: NS_CONCAT({item.name}||' - '||{item.description}||'<br/>') I would additionally add REPLACE to get rid of commas: REPLACE(NS_CONCAT({item.name}||' - '||{item.description}||'<br/>'),',')

In thin the html won’t be supported in the formula text anymore But you can use REPLACE and just hit enter in your formula and it should recognize the carriage return

since the NS_CONCAT uses a comma as the native separate, just add a replace outside of it to convert the "," to "<br/>". Make sure the field type is Formula (HTML). For your fields I think it should look like this:

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