Formula To Get Item Child Name Only

Use the below formula to return only the item child name in a saved search.

REGEXP_REPLACE(REGEXP_SUBSTR({name},’: [^:]+*$’),’: ‘,”)

For example without the formula a parent : child item will display as:

Parent Item Name : Child Item Name

Using the formula only Child Item Name will display.

Leave a comment

Your email address will not be published. Required fields are marked *