in saved search for items, matrix item name returns with : and how can i get rid of it?

AI generated answer (using internal Slack threads):

In NetSuite, when you create a saved search for items, matrix item names are returned in the format of "parent : child". If you want to get rid of the "parent :" part and only display the child item name, you can use a formula in your saved search. Here's how you can do it: 1. In your saved search, go to the Results tab. 2. Click on the 'New Field' button. 3. In the pop-up window, select 'Formula (Text)' as the type. 4. In the formula field, enter the following formula:

CASE WHEN INSTR({itemid},' : ')!=0 THEN SUBSTR({itemid},INSTR({itemid},' : ')+3) ELSE {itemid} END

5. Click on the 'OK' button to save the new field. This formula checks if there is a " : " in the itemid. If it finds one, it takes everything after the " : " (i.e., the child item name). If it doesn't find a " : ", it simply returns the itemid as it is. Please note that this formula works assuming that your itemid is in the format of "parent : child". If your itemid is in a different format, you may need to adjust the formula accordingly. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******