Forum Discussion

sparvez's avatar
sparvez
Helper I
3 years ago

Replace string value in entire table

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-

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

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

    replace with: