Need to add , delimiter in Ingredients column data

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

Common Use Cases

Accepted answers

All comments

binu_acs

@jassik is your data in one row or different rows?nI mean

WATER

CORN SYRUP

SUGAR

MANGO etc

or all in one line of data

Thableaus

Hi @jassik

You have to first identify (or flag) the ingredients with two words or more (corn syrup, mango puree, etc.).

This will make your life easier to create the appropriate rule to replace the spaces by commas.

Thanks,

jassik

It is in one row and I just need to add comma to split the ingredient's name

jassik

Thanks for replying @Thableaus but I am not sure about this I tried different ways but i couldn't solve it

jassik

It is in one row and I just need to add comma to split the ingredient's name @binu_acs exactly how I type in

binu_acs

@jassik is there any pattern in your original data that indicates these words should be within the comma delimiter like CORN SYTUP, MANGO PUREE etc?

danilang

Hi @jassik

As everyone here has mentioned, you need to have a list of multi word ingredients, Corn Syrup, etc. Once you have that list, you can use something like the following

Use a Find Replace tool to replace each of the multi-word ingredients with something not including a space, resulting in "WATER CORN CORN_SYRUP SUGAR MANGO_PUREE MANGOES LEMON_JUICE" Notice that I added an extra CORN to your original list. After that, use a nested replace to first replace space with comma space,", " and then replace the underscores with spaces.

Dan

Ingredients.yxmd

jassik

yes @binu_acs

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:

for jassik.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703