output similarities from two columns into new column

[Inactive User]

how to compare  columns and find similarity and output the similarities in new column

[mceleavey]

@Inactive User 

Can you give us some more information?

Can you post some data and tell us what you're trying to do?

M.

[Inactive User]

above this is 2 column(remarks & item name) for which i would like to compare them. In the remarks column, it contains data which are not structured like ( for one same items each personnel had given their own terminology .) i need to filter it out and make into new column and then filter it out later for analysis 

[mceleavey]

@Inactive User ,

if you post the data rather than a screenshot we can help, but you also need to provide the logic.

What you have said is you would like to compare them but not how. Do you mean match them? Find where Remarks exist in Item Name?

Please provide more information.

M.

[Inactive User]

sample file attached.
i need to filter out remarks column with respect to OWS(component). but due to manual data recording , the terminology used are different . OWS , 15 PPM calibration, oily water separator, calibration & certification 15ppm all these words denote  - OWS component.

\

Basically i want to filter out component - OWS 
1. fuzzy match can be used to group these words and assume it as OWS 

2. or can i find multiple words and replace them with OWS