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.
Solved! Go to Solution.
I Have tried but now able write Regex_Match Can you please help.
Can You Please share the Workflow If Possible ?
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
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