AnsweredAssumed Answered

How to split 3 popcorn flavors in single field into separate fields?

Question asked by straka_sh on Aug 27, 2011
Latest reply on Aug 29, 2011 by LaRetta_1

Title

How to split 3 popcorn flavors in single field into separate fields?

Post

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...

Eg:

Caramel Corn

Cheese Corn

Cashew Thunder

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!

 

Outcomes