mutliple condition

[Johmz]

I need help to formula

FIRST NAME	STATUS
name:orig	Correct
nick:orig | name:orig | last1:orig	Correct
last2:orig | name:orig	Correct
nick:orig | last1:husband | name:orig	Incorrect

Scenario 1: if FIRST NAME column contains name:orig then correct else incorrect

Scenarion 2: if FIRST NAME column contains name:orig and contains last*:orig then correct else incorrect . "*" represent any number after last

Thanks in advance

[alexnajm]

* doesn't work as a wildcard with Contains - you'll have to split it up into Contains last AND contains :orig

Or you'll have to create a Regex_Match to replace it

[flying008 · Accepted solution]

Hi, @Johmz 

FYI.

Spoiler

IIF([FIRST NAME] = 'name:orig' || (Contains([FIRST NAME], 'name:orig') && REGEX_CountMatches([FIRST NAME], 'last\d:orig(?:\s?\||$)')), 'Correct', 'Incorrect')

[Johmz]

can i also use Regex_MATCH if FIRST NAME contains but not equal to last*:orig?

[flying008 · Accepted solution]

Hi, @Johmz 

Yep, you can do it with Regex_Match function.

[Qiu · Accepted solution]

@Johmz 
I feel that we better split the "First Name" column with delimeter "|" then check with your condition.