IF Statement with Wildard in IN

Hello

How do i add a wildcard to the IN ( ) of an IF Statement so i don't have to enter all these variables?

example:

IF [Custom 10 - Name] IN ("COV", "COV WFH", "COV WFH new service", "COVID WFH", "COV - WFH", "COV- WFH", "COVI", "COVI LUNCH") then "Y" else "" endif

Accepted answers

You can't add a wildcard to the list of values but you may be able to use the below formula instead.

IF REGEX_MATCH([Custom 10 - Name], "COV.*") THEN "Y"

ELSE ""

ENDIF

Best,

Michael

Can you provide a sample dataset and explain what didn't work.

I suspect that you have other records that are getting flagged when they shouldn't be. Is that right?

Best,

Michael

All comments

You can't add a wildcard to the list of values but you may be able to use the below formula instead.

IF REGEX_MATCH([Custom 10 - Name], "COV.*") THEN "Y"

ELSE ""

ENDIF

Best,

Michael

You can also use a Contains function: IF Contains([Custom 10-10,"COV") THEN "Y" ELSE "" ENDIF

Thank you but that didn't work for me.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703