Search code examples
netsuitecase-statementsaved-searches

NetSuite Saved Search: Adding replace formula to existing formula


I've created a Saved Search formula LOWER(CONCAT({custitem38}|| ' ', {custitem16})). This is formula is combining values from two custom fields in lower case. For example the result now show like this combining name and color fields "snow jacket orange stripes". I'm now trying to figure out how to replace any spaces with "-" so the results will display as "snow-jacket-orange-stripes"


Solution

  • REPLACE(LOWER(CONCAT({custitem38}||'', {custitem16})), ' ', '-')