How to split 3 popcorn flavors in single field into separate fields?
The field from an import looks like this... "Flavors selected: Caramel Corn, Cheddar Cheese Corn, Cashew Thunder"
However, I'd like to create a calculation that splits it and puts each flavor into a new separate field...
All imports will have the same layout... "Flavors selected: X, Y, Z" and there are about 15 different flavors that could be selected... but it doesn't matter what order they are in... can I use the ":" or "," in some way to split them?
Looking for your expertise!