Find integer in a group of integers

[BonusCup]

Hi,  I'm trying to filter for records where the integer is found in a group of integers like below.

JSON_Name1	Concat_JSON_Name1	Filter
0	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	OUT
10	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	OUT
18	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	IN
32	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	OUT
42	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	IN
80	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	OUT
89	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	IN
101	3,18,28,30,33,40,42,49,51,54,55,68,70,73,76,81,83,89,94,96,97,98,99,100	OUT

I've tried Contains([Concat_JSON_Name1],[JSON_Name1]) but everything still comes across.  TIA

[alexnajm · Accepted solution]

How about this? 

[BonusCup]

@alexnajm thanks, that worked.

[jareds]

I am not sure if I completely understand your question, but could you not just use the following formula?

I have attached a file that also includes a Filter Tool Version.

IF Contains([Concat_JSON_Name1],ToString([JSON_Name1], 0)) THEN "IN" ELSE "OUT" ENDIF

All the best!
Jared

[alexnajm]

Fantastic @BonusCup !

@jareds it doesn’t work for instances like 100 technically containing 10

[BonusCup]

Yes, that was the issue I was having