Input: FruitConcat_fruitappleApple, mango,banana,cherryppleApple, mango,banana,cherrycherryApple,mango,banana,cherryananaApple,mango,banana,cherrymangoApple,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: FruitResultappletruepplefalsecherrytrueananafalsemangotrue

How to match values which is comma seperated

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

Developer

Developer Tools

Common Use Cases

Accepted answers

atcodedog05

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 😀👍

Fruit.yxmd

All comments

atcodedog05

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 😀👍

Fruit.yxmd

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

RgexFruitMatch.yxmd

Assaf_m

check the attached solution,

let me know if it helps

Match.yxmd

Emil_Kos

Hi @Sshasnk,

My is super complicated comparing to other people solutions 🙂

Contains.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703