When I create a saved search and I have the "Name" field in the results, it shows my matrix items in the format of parent : child, but I only want it to show me the name of the item as the "child". For example: it shows the item name as "PIL-BIH-REG : PIL-BIH-REG-2022-A-TIB" but I only want it to show the item name as "PIL-BIH-REG-2022-A-TIB". How do I get it to show the item name that way? Our business process is to have external ID match the name field but now the name field is showing as parent : child, so when I export this report, it looks like they don't match, even though the item name on the item record itself is just "PIL-BIH-REG-2022-A-TIB"

Hi @Dan Warner Looks like your parent item has a consistent length. In this case you may want to try and remove the parent item representation in your search table by using the following Formula (text) SUBSTR({name},14)

@Dan Warner you could also search for the delimitation in the string and start there For example Formula(text) SUBSTR({name}, INSTR({name}, “:”), 100) SUBSTR will display the characters of the name field from a starting and ending point. So SUBSTR({name}, 1, 5) will display the characters of the name field starting at character 1 and going 5 characters from there If you put INSTR({name}, ‘:’) in place of the 1 then it will search the name field for a : and give you the number of characters a : is in the name field. So it will start at the colon and go 100 more characters (or until there are no more

@AK @AI1 There is a field on the item record called

itemid

. The written name of this field is "ITEM NAME/NUMBER". This field shows the item SKU without the parent and colon in front of it. However, the

itemid

field (ITEM NAME/NUMBER field) is not an option when I'm trying to add it to the results of a saved search. How can I get the value in this exact field to show up on my saved search?

I'm not sure. I've never been able to create a saved search of matrix items without having them show the parent : child number as the item number. Did you try to use just ID? Or do formula (text) and put the field {itemid} as the formula