How to filter out value based from another another column?

[villnooB]

Hi

Greatly appreciate your help, would like to know if there is any way i could filter out a value based from another column

I need to filter out anything that column 2 gives to column1 
sample:

column1	column2
apple orange grapes	grapes

expected output
The grape should be removed from column1

column1	column2
apple orange	grapes

will i use where or mvfilter ? 

| where column!=column1

Thank you in advance

[richgalloway]

As with much of SPL, there is more than one way to do that.  The method to use depends on how the current output was produced.  Please share the query.