IF Contains

Hi,

I have some fields that contain several of numbers in each field (e.g.,

line 1 - 1,7,10,17,18,23,66,81,121,122,125,127,130,131,132,133,134,141,289,317,318,324,328,333,334,335,344,348,351,355,356,357,358,369,432,441,462,476

Line 2 -

1,5,6,7,11,15,16,17,18,21,23,31,37,52,56,60,72,83,89,96,127,130,131,137,141,156,239,245,256,257,258,259,263,289,298,314,315,316,317,318,324,333,335,344,346,350,364,365,368,369,370,384,406,436,453,456,462,47

and I wand to know in which filed I have the number 1, 23 and 462.

Will appreciate your help

Thanks

Sahar

Data Investigation

Accepted answers

Thanks!!!!

I used REGEX_Match([Permission IDs], ".*,23,.*") and it works 🙂

All comments

yes you can use contains as:

if contains() and contains() and contains() then .... else ... endif

make sure that you search for numbers that won't find false positives though, like 23 matching to 123.

regex_match([field],"1,.*\b23\b.*\b462.*")

that will find then if they are in sequence.

cheers,

mark

Thanks for your quick reply 🙂

I never used the REGEX_Match and will appreciate your help.

If I need only 23 and not 123 how I write the formula?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703