search multiple texts in a field and then return multiple searched results in a new column

[SD9126]

I have a dataset which has 2 columns: Title, Description. I have a list of keywords which needs to be searched in both fields and then return those searched texts in a new column. If it finds multiple keywords in a single cell then in new column both searched texts should be combined. Please refer to the example below:

Data Structure:

Title	Description
Video Game	PC Game, Mobile Game
Outdoor	Cricket
Board Games	Carrom Board, Dart

Keywords:

Game

Video

Cricket

Board

The output result should be:

Data Structure:

Title	Description	Searched Keywords
Video Game	PC Game, Mobile Game	Game, Video
Outdoor	Cricket	Cricket
Board Games	Carrom Board, Dart	Game, Board

[atcodedog05]

Hi @SD9126 

Here is how you can do it.

Workflow:

Hope this helps : )

[binuacs]

@SD9126  Another option using Find and Replace tool