in a saved search using a fomula, how do I concat all the line item skus names onto a comma separated string

AI generated answer (using internal Slack threads):

In a saved search, you can concatenate all the line item SKUs names onto a comma-separated string using a formula. The formula you would use is

NS_CONCAT({item.name})

. This formula will concatenate all the item names in your line items. However, by default,

NS_CONCAT

uses a comma as the separator. If you want to replace the comma with another character or string, you can use the

REPLACE

function. For example, if you want to replace the comma with a line break, you can use the following formula:

REPLACE(NS_CONCAT({item.name}), ',', '<br>')

Please note that this formula should be used in a Formula (HTML) field. If you don't have the Formula (HTML) option, you might need to ask for a permissions change. If you can't use HTML and you want to export the results to a CSV file, you can use the following formula to add a carriage return instead of a comma:

REPLACE(NS_CONCAT({item.name}), ',', CHR(13) || CHR(10))

Please note that this will not display correctly in the NetSuite UI, but it will when you export the results to a CSV file and enable text wrapping. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******