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.

[ShankerV]

Hi @Rahul6777 

Please make use of REGEX_Match(String, pattern) function.

Many thanks

Shanker V

[Rahul6777]

I Have tried but now able write Regex_Match Can you please help.

[ShankerV]

Hi @Rahul6777 

One way of doing this.

Step 1: Input

Step 2: 

Many thanks

Shanker V

[Rahul6777]

Can You Please share the Workflow If Possible ?

[ShankerV]

Hi @Rahul6777 

Step 3:

Step 4:

Step 5:

Step 6:

Step 7:

Many thanks

Shanker V

[Rahul6777]

 Not Geeting What you have passed Through Input2 Tool, can you please share your workflow so i will try to corelate and check in my scenario.

Thank You

[BRRLL99]

Please try this formula

If REGEX_Match(Category, "^(?!.*Active Image.*).*\bActive\b.*$") Then "True" Else "False" Endif

Using this Formula which has Active will be True

Which has Active Image will be False

[binuacs · Accepted solution]

@Rahul6777 Another way of doing this

[Rahul6777]

Thank You @binuacs @ShankerV and @BRRLL99  for the help and suggestion here.