mutliple condition

Question

I need help to formula

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

flying008 · Accepted Answer

Hi, @Johmz

FYI.

Spoiler

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

flying008 · Accepted Answer

Hi, @Johmz

Yep, you can do it with Regex_Match function.

Qiu · Accepted Answer

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