Input:
Fruit | Concat_fruit |
apple | Apple, mango,banana,cherry |
pple | Apple, mango,banana,cherry |
cherry | Apple,mango,banana,cherry |
anana | Apple,mango,banana,cherry |
mango | Apple,mango,banana,cherry |
I know we can do this using filter but I am using contain function and it is taking pple as true
Output:
Fruit | Result |
apple | true |
pple | false |
cherry | true |
anana | false |
mango | true |
Solved! Go to Solution.
Hi @Sshasnk ,
Here is a workflow for the task.
Input : table given by you
Output:
Workflow :
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
One option would be to use Regular Expressions.
If you replace the , with | then it will work as a one of expression. I chose to use a Regex replace as this will allow the spaces to be replaced to:
REGEX_Replace([Concat_fruit], ",\s*", "|")
Then you can use this in a Regex match with the Fruit:
REGEX_Match([Fruit], REGEX_Replace([Concat_fruit], ",\s*", "|"))
Have attached a sample doing this
Think the simplest might be:
REGEX_Match([Concat_fruit], ".*\b" + [Fruit] + "\b.*")
The \b makes it check for a word boundary (comma or space) so works in this case well.