How to match values which is comma seperated

[Sshasnk]

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

[atcodedog05 · Accepted 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 😀👍

[jdunkerley79]

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

[Assaf_m]

check the attached solution, 

let me know if it helps

[Emil_Kos]

Hi @Sshasnk,

My is super complicated comparing to other people solutions 🙂

[atcodedog05]

Happy to help 🙂 @Sshasnk 

Cheers and Happy Analysing 😀

[jdunkerley79]

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.