Remove one string column from another string column

[tommyhally]

See bottom for picture

I have product names (1st column) 

I also have a seperate flavour column

I want to remove the values in Flavour column from the text string in the Product column

So I would have the Product Description column without "SWEET MANDARIN AND GRAPEFRUIT" (in the first row for example)

This is tricky as you can see the flavour names have different numbers of words and lengths and they do not start at the same point in the text in each row.

Can someone help?

[Felipe_Ribeir0]

Hi @tommyhally 

Try this formula

replace([Product], ' ' + [FLAVOUR], '')

[IraWatt]

Hey @tommyhally,

You could use the replace function to update the products column:

Replace([Product], [FLAVOUR], "")

[JosephSerpis]

Hi @ you can use a replace formula to tackle that challege.

[DataNath]

Hey @tommyhally, you should be able to use the following expression:

Replace([Product], ' '+[FLAVOUR], '')

The ' '+[FLAVOUR] means after removal, there won't be duplicate whitespace.

Examples here:

[tommyhally]

Thanks all for your guidance, this has solved my query - great support