Create lists from a main list.
Hi everyone. recently I have upload all the requiered data in a single list with several properties. One of those list is the full name of the product. Well, what I need to know, if it's possible, is if I can take only the first 3 characters of the name and remove duplicates, in order to create the parents. (the first three characters of all names indicate what group every product is from, many names share the first three characters) for instance: full product name: brk_product1 brk_product2 brk_product3 til_product1 til_product2 I need to pick up only the first 3 characters in order to create parens level and hierarchy. Thank you!