Need to add , delimiter in Ingredients column data

[jassik]

Hello Alteryx community , I  have ingredients column where I have different ingredients with different length of characters. How can I split them with comma(,) delimiter.

For eg: my data is--    WATER CORN SYRUP SUGAR MANGO PUREE MANGOES LEMON JUICE 

and I  want my output :   WATER, CORN SYRUP, SUGAR, MANGO PUREE, MANGOES, LEMON JUICE

Can you please help me with it

[caltang]

Yeah this is quite hard to do. Do you have a list of ingredients that you are aware of? Maybe you could map certain words together as part of a group.

[caltang]

Once you have the list, an alternative to what the others have mentioned above, you can try this: