I am looking for a way ....in which I can search for a list of keywords in a column and have just one replacement word if any of the keywords exists in that column.
Ex: Input String : He went to the park.
Here I want to look for the keywords : park,garden,playground in the input string and have just one word to be given as an output in the result - PARKS
I have a list of many keywords - with diff categories.
Parks,Playgrounds,Gardens------>should give me the output Parks
Apple,orange,grapes----> should give me only Fruits
Is there a way which this can be achieved???
Please sign in to leave a comment.