Replace string value in entire table

[sparvez]

Hello Altrusits,

I have table from where I want to remove 'apple'.  apple may come with additional character. How can I remove only 'apple' from table . Thanks in advance.

Fruit

apple123-orange-grapes

coconut-orange-apple455

tree-apple98

Fruit Filtered

-orange-grapes

coconut-orange-

tree-

[Anonymous]

Select all columns >Transform > Replace Values
value to find: apple

replace with: 

[sparvez]

test