Maybe someone can help me figure this out and hopefully it is a fun one for you guys to figure out. :)
I am trying to separate text from a long list of products. In the middle of the name is either the word "silver" or "gold" and then there is a jewelry type. The problem is that some of the...