I have this formula in a saved search: Replace(ns...
# general
k
I have this formula in a saved search: Replace(ns_concat({memberitem.name}), ',' , ' , ') The search shows the components that are in current Assemblies or Kits. How would I modify it so each result shows on a different line for each A/K? Currently it shows each component separated by a space comma space but I think it would be easier to read with carriage returns.
m
Try formula html = REPLACE(ns_concat({memberitem.name}), ',', '<br>')
k
I don't have Formula (html) as an option. Is there another way to do it without asking for a permissions change?
m
I don't think it has anything to do with permissions. HTML formulas are available just like any other type of formula (text, date, etc.).
k
According to this article, you need permission to be able to use Formula (html): https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/article_0403035152.html#Evaluating-Code-in-Saved-Searches-Using-Formula-(HTML)-Fields I don't have it as an option if I type Formula in the field search.
m
without HTML you can't but you can use formual text like REPLACE(ns_concat({memberitem.name}), ',', CHR(13) || CHR(10)) and export in csv file ( wrapp text)
k
Tried your formula, it's not doing carriage returns for me and having to export it to a CSV every time defeats the purpose.
m
ok so you'll have to use an HTML formula
k
Ok, thanks for trying.