Rejex with conditions

[mmustkee]

Hi Team,

I have a column by the name of DC. I have below criteria. I want to create new column by DC1 and want as below:

if Dc is Null then put as " And Find"

If Dc is not numeric then put as "And Done"

if Dc is <>8 then " And Found" Otherwise DC.

Please refer attached or below:

DC

12345678

34567433

ac

bc

cc

tat

123adsfs

987654

56478

33333333

ac

abcfds

asdfcasd

98765432

xzx12345

Thanks for helping in advance.

Thanks,

mmustkee

[atcodedog05 · Accepted solution]

Hi @mmustkee 

This formula might help you

IF IsNull([DC]) THEN  "And Find" 
ELSEIF !REGEX_Match([DC], "\d+\.?\d*") THEN "And Done" 
ELSEIF [DC]!="8" THEN "And Found" 
ELSE [DC] ENDIF

Workflow:

Hope this helps 🙂

[mmustkee]

Yes, It worked

Thanks a lot.