ANS-0022 · SAVED SEARCHES & FORMULAS
How to Remove Parent Item Names from NetSuite Saved Search Results
Learn how to display item names cleanly in NetSuite saved searches by excluding parent item prefixes.
Short answer
To remove parent item names from NetSuite saved search results, create a Formula Text field. Use the provided formula to parse the item name, effectively stripping the parent prefix. This method is applicable for items with a single level of parentage, ensuring cleaner, more focused search outputs.
Scenario
Users often encounter situations where item names in NetSuite saved search results include the parent item's name, formatted as 'Parent : Child'. This can lead to cluttered reports or make data analysis more challenging when only the child item's name is required. A common need is to display only the child item name, without the parent prefix.
Solution
To remove the parent item name from a saved search result, a Formula Text field can be utilized. This field should be configured with the following formula to parse the item name and display only the child item:CASE WHEN INSTR({name}, ' : ') > 0 THEN SUBSTR({name}, INSTR({name}, ' : ')+3) ELSE {name} ENDIt is important to note that this solution is designed to work effectively with items that have only one level of parentage.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support