Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Display the Child Item Name and Exclude the Parent Item Name in the saved search
Hello everyone,
I need to display the Child Item Name and Exclude the Parent Item Name in the saved search. I have tried the below formulas present in suite answer:
1. ltrim(regexp_substr({item.name},'[^:]$'))
2. REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+$'),': ','')
3. case when {parent} is null then {name} else {feedname} end
4. SUBSTR({name},INSTR({name},':')+2)
None of the above formulas work for me. I cannot find the {feedname} in NetSuite. The child item example: BRAND:11111:MEN : BRAND:11111:MEN:258/TOFFEE BEIGE:29:32 (Bold (parent) : Italic (child))
Would anyone please help me with this?
Thanks in advance