Find Exact Matched String from Concatenated String Column

Rahul6777

Category	Catlo	One	Two	Three	Four	Five	Six
Active,History	TRUE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE
Active,5% History	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
Directory,Active Image, Ownership	FALSE	FALSE	FALSE	TRUE	TRUE	FALSE	FALSE
Ownership	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE
Ownership Details,Active	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE

Hi Team,

Please help on the below logic

in Formula Tab
Logic Calculated Based on: -
Catlo
If Contain(Category, "Active") Then "True" Else False Endif
One
If Contain(Category, "History") Then "True" Else False Endif
Two
If Contain(Category, "Ownership") Then "True" Else False Endif

Now what is the challenge if i am using contain function it will take the as true for other column as well some column contain the word.
Eg. Picking True for Active and Active Image
Picking True for Ownership and Ownership details.

So, i want a function which can help me to pick the exact match String for this concatenated column String.

Please advise.

binu_acs

@Rahul6777 Another way of doing this

FindMatch_220623.yxmd